Excel Project comparing two files

Question

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.

mathetes · Answer

wendywo&nbsp;&nbsp;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?

wendywo · Answer

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

mathetes · Answer

wendywo&nbsp;&nbsp;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&nbsp;XLOOKUPINDEX and MATCH used togetherVLOOKUPand maybe a few others.&nbsp;&nbsp;Here's a website that offers good examples on those and a myriad of other functions in Excel.&nbsp;https://exceljet.net&nbsp;

wendywo · Answer

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

mathetes · Answer

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.&nbsp;

Forum Discussion

Excel Project comparing two files

5 Replies

Resources