Counting Number of Identical Entries in a Spreadsheet Column

  • Thread starter Thread starter Fred 2002
  • Start date Start date
F

Fred 2002

I am using XP Home and Office XP. I use a spreadsheet that has about a
hundred or so lines and a number of columns, one of which is "Agent Number"
in which a four digit number is entered to identify the Agent for that
particular line item. Is there an easy way for me to create a table showing
a ranked order of the number of times each Agent is listed in the column
(e.g., Agent 7818: 20, Agent 7820: 17, etc.)? Thanks in advance!
 
Back
Top