I have a column of text entries that use several suffixes (example A-unc, A-cal; B-unc, B-cal… etc.,)
Is there a way I can sort by suffix
Thanks in advance!
Hallo
=SORTBY( A1:A1000 ; RIGHT( A1:A1000 ; 3 ) )
2 Likes
This function is available since LibreOffice 24.8.
Tested with version: 25.8.7.3 (X86_64)
Build ID: 30742500f2d3eb4366ac312fa33d3dcabdb3eba5
CPU threads: 4; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: es-MX (es_ES); UI: en-US
Calc: CL threaded
The relevant disadvantage is that the output of SORTBY() goes to a locked output range.