Selective count in Excel 1

[flaviooooo]

Hey,
I have a list of random numbers in excel. For example
1
5
5
9
15
12

Now i would like to count how many times each number occurs. Is this possible?

 

[xlbo]

Yup - many ways - in fact, this exact question came up about 2 days ago
1:Use DCOUNT (works for 1 number at a time)
2: Use a pivot table with NUMBER as row field
and COUNT of NUMBER as data field
3: Enter
=countif(A1:A100,A1) in B1 (assuming data starts in A1 and goes on to A100
then copy down Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[SkipVought]

Hi,

Use a Pivot Table. Here's what you need in your table...

1. Each column of data must have a heading
2. the data & headings must be contiguous
3. with your selection in any cell in your table -- Menu Item Data/Pivot Table & Pivot CHart Report...
4. follow the wizard to layout
5. in layout, drag the heading for your numbers to the ROW field
6. in layout, drag the heading for your numbers to the DATA field -- double click on it and select COUNT
7. finish

VOLA! your answer in less than 60 sec!

Skip,
Skip@theofficeexperts.com

 

[flaviooooo]

Thanks guys!

I'm sorry this question came up just 2 days ago :-(