Is there a way to rank alphabets?

D

Derrick

I have a list of names and I need to rank them in order
of ascending alphabets.

How should I do this?

Thanks
 
A

AlfD

Hi!

Not sure what you mean.
Do you want to put the names in alphabetical order (A, then B,..., t
Z)?

If so, use Datas > Sort
Come back if you need something different or mare about Sort.

Al
 
O

olufsen

Hi !

I think I understand what you meen. Try the following:

1. Insert new column where you put your rank letters
2. fill in first three cells in column, example:
cellA1 A
cellA2 B
cellA3 C
3. select cells A1..A3
4. click a little square in the corner of he sellection and keep th
left mouse button pressed. Then extend the selection to the last row i
your data range and release mouse button.

You should get A,B,C,D,E,F.... order in your "Rank" column.

Hope it helped
 
D

Derrick

Maybe I should be clearer in my request.

I actually has a data base of day sales records and among
the fields I have names of customers. There will be
instances where same customer will be repeated in this
data base.

This database is updated daily and thus I will have a
different mix of customers everyday.

I want to extract out the list of customers for the day
(no repeat), sort this list by alphabetical order and
dump them into a drop down list.

I don't want to manually work out this list everyday.
I've created working columns to identify customer names
when they first appear (i.e. will return nil if names
have appeared in earlier rows).

I've prepared a spreadsheet where I have formulas to
extract this list of customers. However, my problem is
that it's presented in the sequence which they appeared,
rather than alphabetically.

Is there a simplier way to do this?
Thanks.
 
Top