ExcelScript Get Rows in Array from Filter

I have an ExcelScript that I want to filter a Column by the State and get all the rows in an array that match that State. This is what I have so far: let selectedSheet = workbook.getActiveWorkshee...

Office Scripts

mathetes
Jul 19, 2023
smithmrk

I can't speak to your VBA/macro question. However, what you've described sounds as if the FILTER function itself might work. If you're not aware of that function--which has only been around for a few years--here's a YouTube video created by Microsoft to introduce it. Worth watching.

Forum Discussion

ExcelScript Get Rows in Array from Filter

Resources