Count() question

[new2XL]

Hello

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

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

I have tried count(), countif(), and frequency() to no avail; an
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 th
condition constraint.

Thanks in advance!!

 

[KellTainer]

Assuming your numbers are from A1 to A10.

in B1, =COUNTIF($A$1:$A$10,A1)

Drag down till B10

 

[new2XL]

thanks for the input, that wasn't quite what I was looking for.

If anyone else understands this issue and is the having the same
problems, see this link:

http://www.ozgrid.com/Excel/count-list.htm

 

[Peo Sjoblom]

=SUMPRODUCT(--(COUNTIF(A1:A10,A1:A10)=1))

will count the numbers that occurs once

for twice

=SUMPRODUCT(--(COUNTIF(A1:A10,A1:A10)=2))/2

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey