In the attached file, Sheet1 has the result of 3 array formulas (2 columns each). I'd like to combine the results somehow so they show as one long list, plus, I'd like to add a column to the left that shows the array it's a result of (in this case, it would show "Cat1", "Cat2", etc.
Thanks for any help you can give.
There is always a way...but I would have to jump into VBA to complete it the way you are working it...
Or make it a dynamic lookup so I can pull the list based on the variable Cat1, Cat2, etc... however many you go through .
Update the J9 Reference to the CAT that you wish to review and it will generate each list... stacking them - Im not brilliant with array formulas so that is going to be tough or creative - cant wait to see if someone drops a good method
Please Login or Register to view this content.
-If you think you are done, Start over - ELeGault
For MS365 Insider
=LET(c,tMaster[[Cat3]:[Cat5]],SORT(HSTACK(TOCOL(IF(c>0,tMaster[[#Headers],[Cat3]:[Cat5]],NA()),2),TOCOL(IF(c>0,tMaster[Kronos Name],NA()),2),TOCOL(IF(c>0,c,NA()),2))))
Other MS365
Please Login or Register to view this content.
Last edited by Bo_Ry; 05-18-2022 at 02:30 AM.
ELeGault - I couldn't quit get yours to work but thanks. Bo_Ry - I knew if someone could come up with a formula it would by youI don't have Insider so can't use that one, but your other one works! I don't understand it of course, but seems to work great - thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks