How can I take a range (a1:a100) that ISN'T sorted and find the number of
unique entries?

=SUM(IF(COUNTIF($A$1:$A$100,$A$1:$A$100)1,0,1))

This is an Array** formula. Press CTRL+SHIFT+Enter to commit the formula to
the cell. This is assuming data is in all 100 cells.
--
John C


"Alan" wrote:

How can I take a range (a1:a100) that ISN'T sorted and find the number of
unique entries?

copy the range to another range, then sort that range...

"Alan" wrote:

How can I take a range (a1:a100) that ISN'T sorted and find the number of
unique entries?

You can use a formula like:
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))
to count the number of unique entries in A1:A10.

You may want to look at Chip Pearson's site. He has lots of techniques to work
with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx


Alan wrote:

How can I take a range (a1:a100) that ISN'T sorted and find the number of
unique entries?

--

Dave Peterson