Trying to use RANK function to parse unique text cells

galadiman

Board Regular
Joined
Apr 4, 2007
Messages
66
OK, so I have a master list of cells with text entries, some repeated.

I'd like to use RANK to get an order for the unique members of this master list, so I can later arrive at a list of only the unique members of this master list. I think I can do the latter part - how do you RANK the text cells?

(please note, many of the cells are identical up to 15th or 20th character, which might preclude jerry-rigging a solution involving ASCII values....)

Thanks for any help.
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Hmm, Those dont get me where I want to go, but they do indicate the difficulty of the question I have posed.

I was looking for a non-vba way to get from this:
a
b
b
a
c
d
e
f
f
g
g

to this:
a
b
c
d
e
f
g

... any ideas?
 
Upvote 0
But actually, the germane question was how to get from this:

a
b
b
a
c
d
e
f
f
g
g

to this:
1
2
2
1
3
4
5
6
6
7
7
 
Upvote 0
Reason: The list may be updated. So I need a way to add a member to the list and have the list automatically 'added-to' in the resulting range, but in alpha order...
 
Upvote 0

Forum statistics

Threads
1,223,195
Messages
6,170,661
Members
452,345
Latest member
ye4hb0i

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top