I have a column of names that contain both blanks and repeated names, for example:
Tom
Frank
Joe
Tom
Alice
Jeff
Frank
I want a function that will return each name in alphabetical order, for instance using the above data:
SMALL(COLUMN ABOVE, 1)="Alice"
SMALL(COLUMN ABOVE, 2)="Frank"
etc.
Basically what Small does on integers, but for Text.
Solved by F. J. in 21 mins