Forum Discussion
Search and Filter Pivot Table
Hello - I am working on two separate files. One is a pivot table with 50K rows, the other is a static excel file with ~200 rows. I'm trying to obtain information from the pivot table easily into the ...
Update: a Filter formula did the trick, is there a way to avoid spill but drag down the 200 rows to capture them all?