Hi friends,
I have a large excel file containing the various name in the one column, which some names may exist several times. Please take a look at the attached file as a small example. I was wondering if there is any way to count different name and generate a output like this:
Citrus sinensis 8
Vitis vinifera 3
so on,
Looking forward to hearing from you soon. Thanks so much for your help in advance
Simplest would be to use a Pivot Table.
http://screencast.com/t/fzrInPduux5
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks so much for your nice solution and presentation.
As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks