Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, any suggestions would be much appreciated.
I need to sort data by the number of times it occurs... for instance column A contains one type of data. Contained in column A is Value X Value X Value Z Value Y Value X Value Y Value Y Value X So what I'm looking for is a command that puts the lines in order by the number of times a value occurs... for instance the above example would be sorted showing all X's at the top of the list as they occur the most... Y would be next, followed by Z since it only occurs once. I'm sorry if I'm not expressing this appropriately, but hopefully you follow what I am needing to do. Thanks in advance to anyone that can help me with this! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Number of Duplicate Occurances | Excel Worksheet Functions | |||
Count number of possible occurances bi-weekly (Can this be done)? | Excel Discussion (Misc queries) | |||
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 | |||
can i calculate the number of occurances of a partucular value? | Excel Worksheet Functions |