Sort worksheet by the number of occurances

[vvaidya]

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

 

[Chip Pearson]

Vinay,

In a column to the right of your data, use the formula

=COUNTIF($F$1:$F5000,F1)

Fill this formula down to the end of your data. Then, sort by that column in
descending order.




--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

 

[Chip Pearson]

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)

 

[vvaidya]

Thanks a lot Chip for your help!
Vinay

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)