Windows XP Ordering texts according to the frequency

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?
 
Joined
Jun 11, 2009
Messages
3
Reaction score
0
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
 
Joined
Jun 11, 2009
Messages
2
Reaction score
0
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?
 
Joined
Jun 11, 2009
Messages
3
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top