Forum Discussion
Solved
Excel Table - Sorting Information in Alphabetical Order With Subdata
I have a report I need to put in alphabetical order, but each title has subtasks beneath it. I want to put all the titles (names in bold) in alphabetical order, but I want the information that goes a...
This might work if you're open to using a formula solution:
=LET(order,SCAN("",names,LAMBDA(a,v,IF(XOR(v={"trevor","cheryl","kim"}),v,a))),SORTBY(data,order,1))More names can be added as needed.
Please see attached workbook sample.
It's do-able. Other than the bold formatting, might there be anything else in the rows with trevor/cheryl/kim that might tell us those are title rows?