Home

URGENT Excel question HELP

%3CLINGO-SUB%20id%3D%22lingo-sub-823784%22%20slang%3D%22en-US%22%3EURGENT%20Excel%20question%20HELP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823784%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3E3)%20Imagine%20I%20have%202%20sets%20of%20similar%20data%20in%20Microsoft%20Excel%2C%20on%202%20different%20tabs.%20How%20might%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eyou%20find%20the%20following%3A%20(%3C%2FSPAN%3E%3CI%3E%3CSPAN%3EFeeling%20industrious%3F%20Include%20a%20table%20with%20your%20work.%3C%2FSPAN%3E%3C%2FI%3E%3CSPAN%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Ea)%20IDs%20found%20in%20tab%201%20but%20not%20in%20tab%202.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eb)%20All%20data%20from%20tab%201%20that%20matches%20IDs%20from%20tab%202.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Ec)%20The%20total%20number%20of%20IDs%20that%20don%E2%80%99t%20match%20between%20the%202%20tabs.%26nbsp%3B%3C%2FSPAN%3ECan%20you%20do%20it%20in%20a%20single%20formula%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-823784%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Evlookup%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-823834%22%20slang%3D%22en-US%22%3ERe%3A%20URGENT%20Excel%20question%20HELP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823834%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398777%22%20target%3D%22_blank%22%3E%40RileyCDeason%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhy%20is%20this%20so%20urgent%3F%20It%20looks%20like%20an%20exam%20question.%20If%20you%20are%20taking%20this%20exam%2C%20you%20will%20certainly%20have%20had%20training%20in%20the%20techniques%20that%20are%20required.%20Asking%20us%20to%20solve%20your%20exam%20question%20for%20you%20feels%20like%20cheating%20to%20me.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
RileyCDeason
Occasional Visitor

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?

1 Reply

Hello @RileyCDeason 

 

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. 

Related Conversations