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
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies