excel - identify and count the number of unique entries in a list

A

arunjoshi

i have a list of numbers in one column, say from cell a1 to cell a10. i
is a lsit of numbers, say these ...

12
13
15
15
15
17
17
20
20
20

(a) i want to write a fuction (or use some other method) to get a tota
count of unique entries in the list. in the example above the tota
number of unique entries is 5.

(a) i also want to be able to generate a list of the unique entries. i
the example above, the list would be: 12, 13, 15, 17, 20
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top