i have a pivot table often required to adjust date range which up to 6 different dates from column A1 to A6. What kind of formula should i use in the "Filter By Condition" > "Custom Formula" based on the date references in A1:A6 so that i don't have to go to filter and select and deselect the date whenever i need the data? Appreciate your help here.
CodePudding user response：
Use this formula to filter data based on the dates that you need and then construct a pivot table from there:
=FILTER(A2:F, MATCH(A2:A, N2:N7,0))
Note: N2:N7 is the range of the dates that you want to filter. You may need to edit that range based on where you have that data.
The best way I found to achieve what you're looking for was filtering data first, then create a pivot table on the results.
