View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] vvaidya@pol.net is offline
external usenet poster
 
Posts: 24
Default Sort worksheet by the number of occurances

Hello:
I would appreciate help with this one.

I have a large worksheet with more than 5000 rows of data (each row
pertaining to one record)
Column F contains account numbers which can occur many times (ie on
many rows) in the worksheet.

I would like to Sort the Worksheet such that the account number that
has occured maximum number of times in column F is all on the top.
Below those rows, will be rows with the second most frequent account
number & so on.

2nd question:
Is there a way to filter the data to show only those rows where the
account numbers have occured more than 10 times in Column F

I really would appreciate any with the above
TIA

Vinay