Forum Discussion

Ric_S_CLT's avatar
Ric_S_CLT
Copper Contributor
Jun 10, 2022
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...
excel
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 10, 2022

    Ric_S_CLT 

    That could be

    =LET( f, FILTER(Table1, Table1[Issue Source] = $A$9),
  INDEX( f, SEQUENCE( ROWS(f) ), XMATCH( A10:D10, Table1[#Headers] ) ) )

    for

Ric_S_CLT's avatar
Ric_S_CLT
Copper Contributor
Jun 10, 2022
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!
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 11, 2022

Ric_S_CLT , you are welcome. It shall work in different sheet, just play with references.

Resources