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?
