Hello

I have a column of nonsequential random numbers some of which are
duplicates.

I am trying to count the the number of numbers that appear once, the
number of numbers that appear twice, and the number of numbers that
appear three times or more.

I have tried count(), countif(), and frequency() to no avail; any
advice?

I've been told countif is the way to go and I know the syntax is:
=countif(cells, condition) but obviously I am having trouble with the
condition constraint.

Thanks in advance!!!


--
new2XL
------------------------------------------------------------------------
new2XL's Profile: http://www.excelforum.com/member.php...o&userid=35161
View this thread: http://www.excelforum.com/showthread...hreadid=549290