Hi,
I attached a workbook.
The workbook contains two tables.
Each Table has data missing that can be found in the other table.
Is there a way to get the missing data from each of the tables?
Thanks!
Hi,
I attached a workbook.
The workbook contains two tables.
Each Table has data missing that can be found in the other table.
Is there a way to get the missing data from each of the tables?
Thanks!
Somehow I get the impression that you just want this done, but in the event that you do want to know how to do so in the future:
- Populate E2 with the following formula and copy down and across to column F:
Please Login or Register to view this content.
- Copy the formula itself to G2 and rearrange the second IF() statement so that the formula reads:
Please Login or Register to view this content.
- Again copy down and across.
- Select copy the data in the four new columns.
- Select A2 and paste special values.
- Here is the file with the above formulas and copy/paste applied.
Copy of Question.xlsx
Let me know if you have any questions.
Thanks,
I actually am glad you gave the formula as it may be useful in the future.
I am relatively new to excel, especially if/And statements.
Once again,
Thanks.
You're welcome and thanks for the feedback. If you have not already done so, please take a moment and mark the thread as 'Solved' using the thread tools link above your first post. Hope that you have a good day.
I combined columns A and B to form one column then combined columns C and D to form another column
Enter in F2 and fill down:
Formula:Please Login or Register to view this content.
Enter in G2 and fill down:
Formula:Please Login or Register to view this content.
Array enter (Ctrl + Shift + Enter) in I2 and fill down. This will combine the contents of columns F and G and remove duplicates at the same time:
Formula:Please Login or Register to view this content.
If you want to separate the values back into 2 columns. Enter this in J2 and fill down:
Formula:Please Login or Register to view this content.
Enter this in K2 and fill down:Formula:Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks