Forum Discussion
MJBob
Mar 08, 2021Copper Contributor
@Matching_dates in disparate columns and related values in adjoining columns
I have to columns of dates (A and C) with values related to each (column B and D, respectively). The dates are not all the same in A and C. I'm looking to find the rows that do match dates and comp...
- Mar 09, 2021
Riny_van_EekelenThis worked perfectly. Thank you for the kindness of your time.
-Martin
Riny_van_Eekelen
Mar 09, 2021Platinum Contributor
MJBob Try this:
Select Cell H4
Put on a Filter
Both columns in the pivot table will now show a filter button
Filter out blanks in both columns to be left with a list that has amounts in both.
MJBob
Mar 09, 2021Copper Contributor
Riny_van_EekelenThis worked perfectly. Thank you for the kindness of your time.
-Martin
- Riny_van_EekelenMar 09, 2021Platinum Contributor
MJBob Glad I could help!