Non-numerical ranking

[BRISBANEBOB]

Is there an equivalent of =rank for non-numerical data? If not, is it possible to sort data (into another column if necessary) alphabetically without resorting to a macro?

[zbor]

Add filter to first row and sort data ascending/descending by column you like.

[BRISBANEBOB]

Thanks for that but the problem is that requires intervention. Sorting numerical data can be done by formula and I'm trying to find a 'string' equivalent...

[zbor]

This can be one way...

In some sheet write numbers from 65 to 90 (i.e. A1 to A26) and use this:

=RANK(CODE(UPPER(D3)),$A$1:$A$26,1)

[pike]

Hi BRISBANEBOB
You can sort A to Z or Z to A

[BRISBANEBOB]

Please can you explain that further - I don't follow it?

Thanks

[BRISBANEBOB]

To clarify the position, I have a list of names, several hundred long, which arrives via a dump. I am trying to 'rank' them alphabetically without intervention. If it was a list of numbers, =rank would give me a value from which I could create an ascending or descending list. This would all be formula-driven. No intervention.

Can that be done with an alpha list?

[pike]

BisvegasBob
like zbor said if you select a column , say a, then click filter , then choose A to Z.

You can search on filter in the excel help for an example.

What version do you have????

[zbor]

Autofilter:

XL 2007: http://www.youtube.com/watch?v=muZRz...eature=related

XL 2003: http://www.youtube.com/watch?v=234GasE_W9k

[pike]

You can organise the dump code?

[BRISBANEBOB]

Hi

I've attached a sample sheet of what I'm trying to do.

Thanks for all ideas.

[pike]

Bisvegasbob
if you copy column f and special paste the value back you can sort by the rank

[DonkeyOte]

BrisbaneBob, FWIW going back to your original question of:

Is there an equivalent of =rank for non-numerical data?

Yes, COUNTIF.

Using your sample file:

Please Login or Register  to view this content.

The 2nd COUNTIF is used to ensure Rank is unique.