New

help on formula

  Excel
HPWC
  HPWC
  Sunday, 06 March 2022
  4 Replies
  10.4K Visits
0
Votes
Undo
Kindly help to provide excel formula for the number of job without duplicate job number for the respective month & year. Thanks in advance.

  Untitled.png
 
0
Oldest First  
Amanda Lee
Amanda Lee
2 years ago
·
#2493
0
Votes
Undo
Hi HPWC,

Sorry that I don't understand you. Can you tell me what result do you want to show in the result boxes?
HPWC
HPWC
2 years ago
·
#2494
0
Votes
Undo
Hi Amanda,

Thanks in advance for your initiative to help. Below is the result :

 [attachment]Untitled_2022-03-14.png[/attachment]
Attachments (1)
HPWC
HPWC
2 years ago
·
#2495
0
Votes
Undo
sorry, I repost the result

 [attachment]Untitled_2022-03-14-2.png[/attachment]
Attachments (1)
emmaericwatson
emmaericwatson
2 years ago
·
#2535
0
Votes
Undo
Please Try countif unique combinations formula
source :
Excel Tips
Ms Office Help
  • Page :
  • 1
There are no replies made for this post yet.