Forum Discussion
Excel Table - Sorting Information in Alphabetical Order With Subdata
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.
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.
- Thank you so much for your help, I found an alternative way to sort the data!!!!! So happy
- Can you please let me know how you did this?? Im trying so hard to do something similar
I will try to explain this as best as I can, but forgive me if it's not explained very well!!
How I solved this problem was by duplicating the entire column with the names and subtasks into another column to the left. After you do this, there should be two columns side by side that are exactly the same. here is an example
dog dog Data nose nose 1 ears ears 2 paws paws 4 cat cat nose nose 1 ears ears 2 paws paws 4 fish fish nose nose 0 ears ears 0 paws paws 0 Then what I did was drag down the "titles" to overlap over the subtasks so it looked like this:
dog dog Data dog nose 1 dog ears 2 dog paws 4 cat cat cat nose 1 cat ears 2 cat paws 4 fish fish fish nose 0 fish ears 0 fish paws 0 after that, you can turn the data into a table and sort the data in alphabetical without messing up the subtasks. you will be sorting the duplicated column to get the titles in alphabetical.
After that's done sorting, you can delete the duplicated column.
This only really works if you have time to go through the data and drag down and duplicate the titles.
Let me know if you have any questions.
