Forum Discussion
excel is there a formulae to do this?
Hello I am trying to make my life a little bit easier, I have several sheets that I would like to extract an entire row using specific criteria in one cell. I am not tech savvy so coding and macros a...
= FILTER(Table1, Table1[faul state]="NT")You didn't mention which version of Excel. The above works in Excel 365 and 2021 by converting the source data to a Table and applying the FILTER function. I was happy to finish with traditional spreadsheet methods, but others feel differently.