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.
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.