Aug 18 2021 05:21 AM - edited Aug 23 2021 05:10 AM
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:
Aug 18 2021 06:18 AM
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?
Aug 18 2021 06:21 AM
Aug 18 2021 06:29 AM
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
Aug 18 2021 07:00 AM
Aug 18 2021 07:08 AM - edited Aug 18 2021 07:11 AM
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.