Hi, I'm currently helping a team quickly gather data based on a value in another column, and I've found the filter function to the best way to dynamically list the array. The full formula is:
=INDEX(FILTER(Table1[#Data],Table1[Group]='Source Data '!L2),SEQUENCE(ROWS(FILTER(Table1[#Data],Table1[Group]='Source Data '!L2))),{27,2,3,20,22,13})
Where I'm using Filter to first list out the rows and Index to list out the columns I need. But I'm using MS 365 for Enterprise while my colleague uses MS 365 ProPlus and she gets the xlfn error in the formula bar. Is there a workaround that can give me the same results for older Excel versions? Especially one that will list the data as an array? Thanks!
Bookmarks