I want to sort Multiple rows of Text individually. I can sort numbers, but not Text. I have attached an example.
Parameters:
Each row will have exactly 5 names; 1 name in each space.
On S2 is where the first name will be located
How it will come out from my raw entry
S2:Aloneet Marissa Simone Octavia Madison
S3:Michelle Monet Anna Octavia Madison
S4:Michelle Aloneet Marissa Madison Anna
S5:Michelle Monet Anna Octavia Simone
S6:Michelle Marissa Anna Octavia Simone
How I will want it sorted after running the macro
S2:Aloneet Madison Marissa Octavia Simone
S3:Anna Madison Michelle Monet Octavia
S4:Aloneet Anna Madison Marissa Michelle
S5:Anna Michelle Monet Octavia Simone
S6:Anna Marissa Michelle Octavia Simone
The step after this is to create an ID I can later use for consolidation. But I know how I will do this.
AloneetMarissaSimoneOctaviaMadison
MichelleMonetAnnaOctaviaMadison
MichelleMonetMarissaMadisonAnna
MichelleMonetAnnaOctaviaSimone
MichelleMarissaAnnaOctaviaSimone
Bookmarks