Hi there is there a formula that counts unique numbers only ?
Ie as per the attached there are 131 numbers but only 10 unique numbers
I think its probasbly some sort of count/frequency but i cant get it to work
Thanks
Hi there is there a formula that counts unique numbers only ?
Ie as per the attached there are 131 numbers but only 10 unique numbers
I think its probasbly some sort of count/frequency but i cant get it to work
Thanks
Last edited by Notters; 10-23-2013 at 11:53 AM. Reason: Solved
Hi,
=SUMPRODUCT(1/COUNTIF(A1:A131,A1:A131))
Regards
Sorry - answer wasn't for counting but creating a list of unique distinct values
Thank you thats perfect
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks