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 static file but I don't want to filter the pivot table 200 separate times. Would there be an easier way to obtain the information? I can try xlookup but running into data latency issues and there are sometimes 4 inputs to one of the corresponding numbers. No PowerBI unfortunately.
- Update: a Filter formula did the trick, is there a way to avoid spill but drag down the 200 rows to capture them all?
