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