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
Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Similar threads
- Question
- Question
- Question
