LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ralph
 
Posts: n/a
Default Counting # of Times an Item Shows Up in a Table

Hi,

Is there a way to select a table and have excel produce a list ranking the #
of times each item shows up in the list, i.e.

dog 5
cat 2
bird 1
???

Thanks
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Calculated field item Tim Excel Discussion (Misc queries) 1 September 24th 05 12:31 AM
Pivot table column duplicates Kerry Excel Discussion (Misc queries) 3 September 15th 05 07:26 PM
Counting the number of times a word appears in a worksheet Jig Bhakta Excel Worksheet Functions 4 February 3rd 05 03:01 AM
Pivot table and counting ChristopherH Excel Worksheet Functions 1 November 20th 04 01:26 PM
showing the # of times an item is entered in a column Foreplay_Man Excel Worksheet Functions 3 November 10th 04 04:28 PM


All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"