calculate how many times a number appears 2

[gdgrl]

If I select a group of cells with numbers, how do I find out how many times each number appears. I would like to see
the calculations in a list if possible.

 

[SkipVought]

Hi,

Use the DCOUNT function and put your criteria in a range -- works good! Skip,
Skip@theofficeexperts.com

 

[xlbo]

If your list is in A1:A100 (header in A1), you could:
A: Use DCOUNT as Skip suggests
B: Use a pivot table with
Number as row field and
COUNT of number as data field
C: Use =countif(A2:A100,A2) and copy down
Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[gdgrl]

Thank you guys!!!