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 |
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 |