Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count number of occurances between 2 values | Excel Worksheet Functions | |||
help w/ sorting by number of occurances... | Excel Discussion (Misc queries) | |||
Count Number of Duplicate Occurances | Excel Worksheet Functions | |||
countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
chart the number of occurances | Charts and Charting in Excel |