3) Imagine I have 2 sets of similar data in Microsoft Excel, on 2 different tabs. How might
you find the following: (Feeling industrious? Include a table with your work.) a) IDs found in tab 1 but not in tab 2.
b) All data from tab 1 that matches IDs from tab 2.
c) The total number of IDs that don’t match between the 2 tabs. Can you do it in a single formula?
Why is this so urgent? It looks like an exam question. If you are taking this exam, you will certainly have had training in the techniques that are required. Asking us to solve your exam question for you feels like cheating to me.
April 24, 2020