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

Sort worksheet by the number of occurances
 

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)



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

Sort worksheet by the number of occurances
 

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

Sort worksheet by the number of occurances
 

Thanks a lot Chip for your help!
Vinay

Chip Pearson wrote:
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