Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Sunday, 06 March 2022
  4 Replies
  10K 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
 
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?
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)
2 years ago
·
#2495
0
Votes
Undo
sorry, I repost the result

 [attachment]Untitled_2022-03-14-2.png[/attachment]
Attachments (1)
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.