For your Filter question, use Advanced Filter and enter 10 for the COUNTIF
Column described in my previous reply.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
wrote in message
ups.com...
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