I have 6 columns of Excel data, 3 sets of date/times matched with data points. The only problem is that the date/times are on different intervals. I want to only keep date/times that have all 3 data points.
For example, if I had:
Set A: 1/10 7 1/11 8 1/12 13 Set B: 1/10 6 1/12 5 1/14 3 Set C: 1/9 4 1/10 3 1/11 14 1/12 5
I'd want to keep only the data for 1/10 and 1/12. Is there an easy way to do this? Thanks!
To make it more specific, my spreadsheet has 6 columns of data: Column A has dates/times where data exists for commodity 1, and then column B contains the value of commodity 1 at those dates/times. Similar for C/D and E/F. I want to filter it so that each column only contains data points associated with a date/time that all columns have data for.