I have two tables above, in which minor_bay variable is common in both. I like to get a new table using a command that pulls out date variable (table1) rows that fall within two date range (in table 2) and have matching minor bay variables. Can anyone help to make a command using excel?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Joining two tables using multi-criteria (date range and matching col variable)
- Thread starter spaudel
- Start date
I have two tables above, in which minor_bay variable is common in both. I like to get a new table using a command that pulls out date variable (table1) rows that fall within two date range (in table 2) and have matching minor bay variables. Can anyone help to make a command using excel?
Excel Facts
How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Similar threads
- Question
- Question
- Question
