Try...
=SUM(1/COUNTIF(A1:A6,A1:A6))
This is a CSE formula which requires Ctrl + Shift + Enter
Try...
=SUM(1/COUNTIF(A1:A6,A1:A6))
This is a CSE formula which requires Ctrl + Shift + Enter
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks