Excel Project comparing two files

%3CLINGO-SUB%20id%3D%22lingo-sub-2660300%22%20slang%3D%22en-US%22%3EExcel%20Project%20comparing%20two%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2660300%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20project%20Can%20you%20please%20help%20me%20to%20understand%20the%20question.%3C%2FP%3E%3CP%3EAs%20an%20output%2C%20please%2C%20prepare%3A%3C%2FP%3E%3CP%3Eo%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20a%20new%20spreadsheet%20that%20will%20show%20which%20columns%20from%20file2%20should%20be%20used%20to%20update%20the%20corresponding%20columns%20from%20file1%3B%3C%2FP%3E%3CP%3Eo%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20a%20separate%20tab%20in%20file2%20with%20pivot%20tables%20on%20it%20which%20will%20show%3A%3C%2FP%3E%3CUL%3E%3CLI%3Edistribution%20(quantity)%20of%20the%20unique%20BC_ID%20by%20Postal%20State%2C%20sorted%20descending%3B%3C%2FLI%3E%3CLI%3Equantity%20of%20unique%20BC_ID%20opened%20in%202010%2C%202011%2C%202012%20and%202013%20by%20year%20%E2%80%93%20column%20Open%20Date.%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2660300%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2660578%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Project%20comparing%20two%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2660578%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131314%22%20target%3D%22_blank%22%3E%40wendywo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20a%20homework%20assignment%20for%20a%20course%20you're%20taking%3F%20It%20sounds%20like%20it.%20In%20which%20case%2C%20don't%20you%20think%20you%20should%20be%20researching%20it%20more%20on%20your%20own%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2660581%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Project%20comparing%20two%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2660581%22%20slang%3D%22en-US%22%3EYes%20I%20just%20need%20help%20to%20understand.%20Especially%20for%20the%20first%20question%20I%20am%20not%20asking%20somebody%20to%20do%20everything.%20I%20just%20need%20a%20guide%20to%20show%20me%20the%20way%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2660601%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Project%20comparing%20two%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2660601%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1131314%22%20target%3D%22_blank%22%3E%40wendywo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20will%20need%20to%20become%20familiar%20with%20some%20of%20the%20various%20functions%20that%20enable%20you%20to%20take%20something%20like%20an%20ID%20from%20one%20record%20in%20one%20file%20and%20go%20using%20that%20ID%20to%20lookup%20the%20values%20in%20another%20sheet.%3C%2FP%3E%3CP%3EYou%20might%20want%20to%20familiarize%20yourself%2C%20therefore%2C%20with%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EXLOOKUP%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EINDEX%3C%2FSTRONG%3E%20and%20%3CSTRONG%3EMATCH%3C%2FSTRONG%3E%20used%20together%3C%2FP%3E%3CP%3E%3CSTRONG%3EVLOOKUP%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3Eand%20maybe%20a%20few%20others.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20a%20website%20that%20offers%20good%20examples%20on%20those%20and%20a%20myriad%20of%20other%20functions%20in%20Excel.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a project Can you please help me to understand the question.

a new spreadsheet that will show which columns from file2 should be used to update the corresponding columns from file

a separate tab in file2 with pivot tables on it which will show:

  • distribution (quantity) of the unique BC_ID by Postal State, sorted descending;
  • quantity of unique BC_ID opened in 2010, 2011, 2012 and 2013 by year – column Open Date.
5 Replies

@wendywo 

 

Is this a homework assignment for a course you're taking? It sounds like it. In which case, don't you think you should be researching it more on your own?

Yes I just need help to understand. Especially for the first question I am not asking somebody to do everything. I just need a guide to show me the way

@wendywo 

 

You will need to become familiar with some of the various functions that enable you to take something like an ID from one record in one file and go using that ID to lookup the values in another sheet.

You might want to familiarize yourself, therefore, with 

XLOOKUP

INDEX and MATCH used together

VLOOKUP

and maybe a few others. 

 

Here's a website that offers good examples on those and a myriad of other functions in Excel. https://exceljet.net

 

Thank you for your help but I need some answers specific to the my project

Those were intended to be specific to your project. They're (to the extent I understand the project) the Excel functions that would apply as starters. Given that it's a course assignment, you'll learn more through digging around and trying things out...the assignment presumes a fair degree of familiarity with Excel, and maybe that you and your fellow students have some manuals and reference works.