Mar 08 2021 09:22 AM
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 compare their respective values (same row, next column) so that a chart comparing the relative values of only matching dates can be created. Ideas?
Mar 08 2021 09:53 AM
@MJBob Not sure I follow, but perhaps a Pivot Table could achieve what you want. It needs a slight restructure of your data though. Example is attached.
Mar 08 2021 10:32 AM
Mar 09 2021 12:21 AM
@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.
Mar 09 2021 07:43 AM
Solution@Riny_van_EekelenThis worked perfectly. Thank you for the kindness of your time.
-Martin
Mar 09 2021 08:13 AM
@MJBob Glad I could help!
Mar 09 2021 07:43 AM
Solution@Riny_van_EekelenThis worked perfectly. Thank you for the kindness of your time.
-Martin