Forum Discussion
Excel pivot table search question
- Mar 26, 2020
This sample on PivotTable with dates, but that doesn't matter. My initial filter
after I do the search and add data to filter
Result is
Hi, Suppose that you have an excel file with 10K rows of data and 10 columns, where one of the columns is an ID (6 digit number) column. You have multiple rows of data associated with multiple IDs, i.e you can have 500 rows of data with Id#1, 200 rows of data associated with Id#2, 400 rows of data associated with ID#3... until Id#50. I need to gather data for Ids# 1, #10, #15, #35. I create a pivot table by selecting my rage, Insert, Pivot Table, then selecting my filters and my rows of data. One of my filters is called "Id", which is a 6 digit number. If I need to find a 6 digit number ID, I just type the number on the filter box and all items with that number will be checked. Now, I need to find a different ID keeping the first one checked. Once I try searching again, the first search is unchecked. As I have 50 different IDs and have to select 4 of 5 of them, how can I search, select and move to the next search without unchecking the first Id? I just need to add to my search without unchecking the first search. Thank you!
This sample on PivotTable with dates, but that doesn't matter. My initial filter
after I do the search and add data to filter
Result is
- CW_Excel123Mar 26, 2020Copper Contributor
- SergeiBaklanMar 27, 2020Diamond Contributor
CW_Excel123 , you are welcome, glad to help