In the attached example I need a formula to provide the numbers shown in column E.
Basically, how many unique values are there in column B where the month in column A is Jan, Feb, Mar etc?
Forum ExampleApr 3.xlsx
In the attached example I need a formula to provide the numbers shown in column E.
Basically, how many unique values are there in column B where the month in column A is Jan, Feb, Mar etc?
Forum ExampleApr 3.xlsx
How aboutFormula:
Please Login or Register to view this content.
Thank you, that worked
You're welcome & thanks for the feedback.
Alternatively something like this:
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks