| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort column by amount of same content cells
I got data in column A, B C and D
I need to sort by column A based on the quantity of cells with same content. I got this: banana banana boat tape banana boat I need it sorted like this: banana banana banana boat boat tape Is that possible? Regards Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort column by amount of same content cells
Use column E as a helper column, with a formula like:
=COUNTIF(A$1:A$100,A1) This assumes you have 100 rows of data - adjust to suit and copy this down. Then you can sort the range A1:E100, using column E as the sort key. Afterwards, you can delete column E. Hope this helps. Pete On Aug 21, 8:37 pm, "Mike M" wrote: I got data in column A, B C and D I need to sort by column A based on the quantity of cells with same content. I got this: banana banana boat tape banana boat I need it sorted like this: banana banana banana boat boat tape Is that possible? Regards Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
| Sort column by second word in cells | Setting up and Configuration of Excel | |||
| I can't sort data when the key column cells contain formula | Excel Discussion (Misc queries) | |||
| Sort subs. by amount | Excel Discussion (Misc queries) | |||
| Sort columns by content | Excel Worksheet Functions | |||
![Mike M[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
