Please see the attached excel sample.
We have something like this:
excel forum question.PNG
And we want the formula to get the event count on Col D (see first sample values).
How do we do it?
Please see the attached excel sample.
We have something like this:
excel forum question.PNG
And we want the formula to get the event count on Col D (see first sample values).
How do we do it?
Try this in D3:
Enter with Ctrl+Shift+Enter to create an array formula. Then copy to D4, D5 etc. This formula ignores duplicate values.Please Login or Register to view this content.
WBD
Office 365 on Windows 11, looking for ✶ rep!
Ah.. perfect!
Thanks a million!
@Victoriaviolet
You were warned yesterday about pointless posts and ones that fail to address the issue in the thread. This is your FINAL warning. Please desist.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks