SOLVED

@Matching_dates in disparate columns and related values in adjoining columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2193779%22%20slang%3D%22en-US%22%3E%40Matching_dates%20in%20disparate%20columns%20and%20related%20values%20in%20adjoining%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2193779%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20to%20columns%20of%20dates%20(A%20and%20C)%20with%20values%20related%20to%20each%20(column%20B%20and%20D%2C%20respectively).%26nbsp%3B%20The%20dates%20are%20not%20all%20the%20same%20in%20A%20and%20C.%26nbsp%3B%20I'm%20looking%20to%20find%20the%20rows%20that%20do%20match%20dates%20and%20compare%20their%20respective%20values%20(same%20row%2C%20next%20column)%20so%20that%20a%20chart%20comparing%20the%20relative%20values%20of%20only%20matching%20dates%20can%20be%20created.%26nbsp%3B%20Ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2193779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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?

5 Replies

@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.

 

Thank you for the sample. What I'm trying to do is find common dates for the two data sets -- in essence see all rows that have data for both "market" and "recorded" only when they can be compared (no blanks). You pivot table gets me part of the way there, but how do I remove the rows with blanks? Looks like I'm going to have to take a refresher on Pivot Tables, too! Again, thank you for your expertise and help. - Martin

@MJBob Try this:

Select Cell H4

Screenshot 2021-03-09 at 09.07.58.png

Put on a Filter

Screenshot 2021-03-09 at 09.09.53.png

Both columns in the pivot table will now show a filter button

Screenshot 2021-03-09 at 09.08.19.png

Filter out blanks in both columns to be left with a list that has amounts in both.

Screenshot 2021-03-09 at 09.08.49.png

best response confirmed by MJBob (New Contributor)
Solution

@Riny_van_EekelenThis worked perfectly.  Thank you for the kindness of your time.

-Martin