Forum Discussion
Solved
Subset of data
I run a weekly report, using a filtered dump of data from a company database. The database is maintained by a utility department with a large user forum; in response to user forum requests, data fiel...
That could be
=LET( f, FILTER(Table1, Table1[Issue Source] = $A$9), INDEX( f, SEQUENCE( ROWS(f) ), XMATCH( A10:D10, Table1[#Headers] ) ) )for
That could be
=LET( f, FILTER(Table1, Table1[Issue Source] = $A$9),
INDEX( f, SEQUENCE( ROWS(f) ), XMATCH( A10:D10, Table1[#Headers] ) ) )for
Nice, thank you! That worked. Had to play with it for a bit - didn't seem to want to work when I started the new table in a different tab, but did work when I started the new table in the same tab and then cut-and-pasted into a new tab. Thanks again!
Ric_S_CLT , you are welcome. It shall work in different sheet, just play with references.