help on formula
By HPWC on Sunday, 06 March 2022
Posted in Excel
Replies 4
Likes 0
Views 10.4K
Votes 0
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

 
Hi HPWC,

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

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

 [attachment]Untitled_2022-03-14.png[/attachment]
HPWC
·
2 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
sorry, I repost the result

 [attachment]Untitled_2022-03-14-2.png[/attachment]
HPWC
·
2 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Please Try countif unique combinations formula
source :
Excel Tips
Ms Office Help
emmaericwatson
·
2 years ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post