LinkBack URL
About LinkBacks
Because A1 is a header, the range starts on A2. Adjust the ending cell to suit. You can use this formula to get the number of unique, non-blank entries in the range:
=SUMPRODUCT(--(A2:A10<>"")/COUNTIF(A2:A10,A2:A10&""))
Because A1 is a header, the range starts on A2. Adjust the ending cell to suit. You can use this formula to get the number of unique, non-blank entries in the range:
=SUMPRODUCT(--(A2:A10<>"")/COUNTIF(A2:A10,A2:A10&""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks