Sorting a range on the last word

[Mark McInerney]

Hi Folks - Thanks in advance for taking a look a this.

I have a range of data - is it possible to sort it by the last word?

Arunas Liktoravicius - 0002 - Shop/Carwash

Callum Hurley - 0028 - Shop/Carwash

Christian Stuart - 0026 - Shop/Carwash

Cian Merriman - 0034 - Shop/Carwash

Fang Li - 0035 - Deli

Fiona O Connor - 0009 - Manager/Supervisor

Karl O Connor - 0012 - Manager/Supervisor

Kate Hudson - 0013 - Shop/Carwash

Kenneth O Connor - 0014 - Manager/Supervisor

Krysztof Ignatowicz - 0015 - Shop/Carwash

Mindaugas Serva - 0017 - Shop/Carwash

Molly Wood - 0031 - Deli

Monika Gos - 0018 - Deli

Radoslaw Gawor - 0020 - Shop/Carwash

Ron Hall - 0022 - Shop/Carwash

Rory O Connell - 0033 - Shop/Carwash

Sara Orellana Olivera - 0023 - Deli

Waldemar Szut - 0024 - Cornelscourt

Waldemar Szut - 0024 - Shop/Carwash

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1
2	Arunas Liktoravicius - 0002 - Shop/Carwash		Arunas Liktoravicius - 0002 - Shop/Carwash
3	Callum Hurley - 0028 - Shop/Carwash		Callum Hurley - 0028 - Shop/Carwash
4	Christian Stuart - 0026 - Shop/Carwash		Christian Stuart - 0026 - Shop/Carwash
5	Cian Merriman - 0034 - Shop/Carwash		Cian Merriman - 0034 - Shop/Carwash
6	Fang Li - 0035 - Deli		Kate Hudson - 0013 - Shop/Carwash
7	Fiona O Connor - 0009 - Manager/Supervisor		Krysztof Ignatowicz - 0015 - Shop/Carwash
8	Karl O Connor - 0012 - Manager/Supervisor		Mindaugas Serva - 0017 - Shop/Carwash
9	Kate Hudson - 0013 - Shop/Carwash		Radoslaw Gawor - 0020 - Shop/Carwash
10	Kenneth O Connor - 0014 - Manager/Supervisor		Ron Hall - 0022 - Shop/Carwash
11	Krysztof Ignatowicz - 0015 - Shop/Carwash		Rory O Connell - 0033 - Shop/Carwash
12	Mindaugas Serva - 0017 - Shop/Carwash		Waldemar Szut - 0024 - Shop/Carwash
13	Molly Wood - 0031 - Deli		Waldemar Szut - 0024 - Cornelscourt
14	Monika Gos - 0018 - Deli		Fang Li - 0035 - Deli
15	Radoslaw Gawor - 0020 - Shop/Carwash		Molly Wood - 0031 - Deli
16	Ron Hall - 0022 - Shop/Carwash		Monika Gos - 0018 - Deli
17	Rory O Connell - 0033 - Shop/Carwash		Sara Orellana Olivera - 0023 - Deli
18	Sara Orellana Olivera - 0023 - Deli		Fiona O Connor - 0009 - Manager/Supervisor
19	Waldemar Szut - 0024 - Cornelscourt		Karl O Connor - 0012 - Manager/Supervisor
20	Waldemar Szut - 0024 - Shop/Carwash		Kenneth O Connor - 0014 - Manager/Supervisor
Sheet5

Cell Formulas
Range	Formula
C2:C20	C2	=SORTBY(A2:A20,TEXTAFTER(A2:A20,{"/"," "},-1))
Dynamic array formulas.

 

[Mark McInerney]

Fluff to the rescue...(again) - Thanks for looking at this - appreciated.

I'm treating the last word as one with no breaks or gaps - "Deli" is treated as "Shop/Carwash" - Can I use two Text afters and link to the second " - " value that is found and return the text after that?

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1
2	Arunas Liktoravicius - 0002 - Shop/Carwash		Waldemar Szut - 0024 - Cornelscourt
3	Callum Hurley - 0028 - Shop/Carwash		Fang Li - 0035 - Deli
4	Christian Stuart - 0026 - Shop/Carwash		Molly Wood - 0031 - Deli
5	Cian Merriman - 0034 - Shop/Carwash		Monika Gos - 0018 - Deli
6	Fang Li - 0035 - Deli		Sara Orellana Olivera - 0023 - Deli
7	Fiona O Connor - 0009 - Manager/Supervisor		Fiona O Connor - 0009 - Manager/Supervisor
8	Karl O Connor - 0012 - Manager/Supervisor		Karl O Connor - 0012 - Manager/Supervisor
9	Kate Hudson - 0013 - Shop/Carwash		Kenneth O Connor - 0014 - Manager/Supervisor
10	Kenneth O Connor - 0014 - Manager/Supervisor		Arunas Liktoravicius - 0002 - Shop/Carwash
11	Krysztof Ignatowicz - 0015 - Shop/Carwash		Callum Hurley - 0028 - Shop/Carwash
12	Mindaugas Serva - 0017 - Shop/Carwash		Christian Stuart - 0026 - Shop/Carwash
13	Molly Wood - 0031 - Deli		Cian Merriman - 0034 - Shop/Carwash
14	Monika Gos - 0018 - Deli		Kate Hudson - 0013 - Shop/Carwash
15	Radoslaw Gawor - 0020 - Shop/Carwash		Krysztof Ignatowicz - 0015 - Shop/Carwash
16	Ron Hall - 0022 - Shop/Carwash		Mindaugas Serva - 0017 - Shop/Carwash
17	Rory O Connell - 0033 - Shop/Carwash		Radoslaw Gawor - 0020 - Shop/Carwash
18	Sara Orellana Olivera - 0023 - Deli		Ron Hall - 0022 - Shop/Carwash
19	Waldemar Szut - 0024 - Cornelscourt		Rory O Connell - 0033 - Shop/Carwash
20	Waldemar Szut - 0024 - Shop/Carwash		Waldemar Szut - 0024 - Shop/Carwash
Sheet5

Cell Formulas
Range	Formula
C2:C20	C2	=SORTBY(A2:A20,TEXTAFTER(A2:A20," ",-1))
Dynamic array formulas.

 

[Mark McInerney]

Hi Fluff - Genius as always...now look what you made me do...and it works! Many Thanks as always.

=SORTBY(UNIQUE(FILTER(Payroll_Employee_Name,(Payroll_Year=W2)*(Payroll_Week=AA2))),TEXTAFTER(UNIQUE(FILTER(Payroll_Employee_Name,(Payroll_Year=W2)*(Payroll_Week=AA2)))," ",-1))

 

[Fluff]

You're welcome & thanks for the feedback.