I was asked by an excel user today and don't know the answer is this
possible? What would I google?

I have a column like.

1
1
1
1
2
2
2
3
3

How can I have excel how many times the #1, #2 and #3 appear in that column?
Without VBA?

HotRod

Check out the COUNTIF Function, something like...

=COUNTIF($A$1:$A$100,A1)

This will count the occurrences in A1:A100 of the data in A1 and of course
A2, 3, etc as you copy it down

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"HotRod" wrote in message
...
I was asked by an excel user today and don't know the answer is this
possible? What would I google?

I have a column like.

1
1
1
1
2
2
2
3
3

How can I have excel how many times the #1, #2 and #3 appear in that
column? Without VBA?

=COUNTIF(A1:A100,1) will count the number of times 1 occurs in the range

BTW the EXCEL.MISC or EXCEL.WORKFUNCTIONS newsgroup would have been more
appropriate for a non-programming question

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"HotRod" wrote in message
...
I was asked by an excel user today and don't know the answer is this
possible? What would I google?

I have a column like.

1
1
1
1
2
2
2
3
3

How can I have excel how many times the #1, #2 and #3 appear in that
column? Without VBA?

=COUNTIF(A:A,1)

etc.
--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"HotRod" wrote in message
...
I was asked by an excel user today and don't know the answer is this
possible? What would I google?

I have a column like.

1
1
1
1
2
2
2
3
3

How can I have excel how many times the #1, #2 and #3 appear in that
column?
Without VBA?

THANKS, I was hoping for more of a filtering type answer as the users aren't
even this advanced.

Hi

If you wanted to use filtering, then assuming your Data is column A,
with a heading in A1 called Data, and your values in cells A2:A100.
Insert a new row above your header row and enter in cell A1
=SUBTOTAL3(A3:A100)
Place cursor in cell A2 and DataFilterAutofilter
Use the dropdown to select the number required, and cell A1 will display
a count of the visible rows of data containing that number.
--
Regards

Roger Govier


"HotRod" wrote in message
...
THANKS, I was hoping for more of a filtering type answer as the users
aren't even this advanced.

THANKS that ma be easy enough for them to follow.

Do it Pivot, it's simply way to do it!