LinkBack URL
About LinkBacks
Hello all,
From a column of random numbers; I want to select distinct number in excel.
I tried with Countif function to count distinct formula in excel.
Regards,
Vikas
Hello all,
From a column of random numbers; I want to select distinct number in excel.
I tried with Countif function to count distinct formula in excel.
Regards,
Vikas
=SUM(IF(FREQUENCY(A2:A10,A2:A10)>0,1))
Counts the number of unique number values in cells A2:A10, but does not count blank cells or text values (4)
see if this works
otherwise share a sample file
This will count unique text and numbers.
Enter with Ctrl + Shift + Enter
Formula:
Please Login or Register to view this content.
From: J.E. McGimpsey
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks