Hello,
I am looking to count nonblanks in column A contiguously but counting the duplicates only once. Here is an example below:
A B
1 Andrew
2 Kevin
3 Jenny
1 Andrew
4 James
Can someone help with a formula in Column A that can do this? Thanks so much
Using your posted example, this regular formula returns the count of unique, non-blank combinations:
Formula:
Please Login or Register to view this content.
With your data, that formula returns: 4
Is that something you can work with?
If your list starts in B2, this formula in A2 and dragged down should also work:
Formula:Please Login or Register to view this content.
Please click the * icon below if I have helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks