How to count repeating values

Running Excel 2000 on Windows XP Pro.  

I have a column containing repeating values.  I want to get a count of each repeating value.
For example, column F has the word "apple" in several cells.  in the same column there are many cells containing  the word "bake".  

What function would count the cells in the row and tell me how many contain "bake" and how many contain "apple" ?
donpickAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saqib Husain, SyedEngineerCommented:
=countif(A:A,"apple")
0
Saqib Husain, SyedEngineerCommented:
Or if B1 contains apple then you can use

=countif(A:A,B1)
0
Glenn RayExcel VBA DeveloperCommented:
Your question also seems to suggest that you would like to see a list of all values and the number of occurrences of each.  In that case, I would suggest creating a Pivot Table.  

The column will need a header row (a label on the top) and that row will specify both the Row values and the data values in the Pivot Table.  The function should automatically provide a COUNT of the number of each item listed.

I have attached an example file that I hope you are able to open in Excel 2000 and see.
EE-Pivot-Example.xls
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Saqib Husain, SyedEngineerCommented:
GlennLRay,

Since the asker is looking for count of "repeating" values it would be a good idea to filter your pivot table to that effect.
0
donpickAuthor Commented:
Thank you for providing an example of a pivot table.  I have never used pivot tables.
0
Glenn RayExcel VBA DeveloperCommented:
Glad to help.  PivotTables are amazingly powerful and are especially good at *ad hoc* analysis of your data.
-Glenn
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.