Windows XP Ordering texts according to the frequency

D

darumla

Joined
Jun 11, 2009
Messages
2
Reaction score
0
Hi,
I have an excel file in which there are lots of text. I want to order them according to their frequency. For example, if there are fifty times of "darumla", I want darumla to be at the top row. How could I do that?
 
Assuming you have column headings in row 1:

Add a column called 'sort'
If your text is in column A, add the following formula to row 2 in the 'sort' column':
Code: 
=COUNTIF(A:A,A2)
Copy this down all the columns in your spreadsheet. This will count the number of rows that match the text in column A
Sort the table by the 'sort' column in descending order.

Regards

Pip
 
Thank you. However, can you assume that there are lots of words that are repated trought the text. For example,

darumla
pip
pip
darumla
pip
pc
pc
pc
pc
My aim is to make this list sorted to
pc
pc
pc
pc
pip
pip
pip
darumla
darumla
Is there a way for this?
 
Try it!

Each row will have the same count against it, so in your example,
all the 'pc' entries will have a count of 4, all the 'pip's 3 and daruma 2
If you sort descending by the count you should end up with the result you want

I've put you example in a spreadsheet:

NAME COUNT
pc 4
pc 4
pc 4
pc 4
pip 3
pip 3
pip 3
darumla 2
darumla 2
 
Back
Top