Hello Everyone,
I have a sheet in which 40,000 rows. I need to determine the number of distinct (unique) values in column A. Is there any way to distinct the unique values in Excel.
Thanks for help
Ankit
Hello Everyone,
I have a sheet in which 40,000 rows. I need to determine the number of distinct (unique) values in column A. Is there any way to distinct the unique values in Excel.
Thanks for help
Ankit
Distinct = all values that appear at least once
Unique = values that only appear once
Which do you need?
http://www.get-digital-help.com/get-...crosoft-excel/
PS Why don't you use Google for this type of questions?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks