I am struggling trying to find a solution for this problem.
Scenario... Excel file with three worksheets titled 2018, 2019, and 2020.
Each worksheet has the following columns... seller ID, seller name, total sales, total units.
The rows contain a bunch of customers with the above information. Some customers are found on all three worksheets, some customers are only found on one or two worksheets. Every year we will add a new worksheet with that year's data.
What I'm trying to get... I need a report (pivot table, power bi, ?what ever) that will pull the following data.. customer ID, customer name and let's say the 2019 and 2020 total sales figures side by side. Ideally, I would like an additional column with the differential between the two years figures. Can anyone suggest something to do this comparison for me?
44 freelancere byder i gennemsnit $131 på dette job
Hi, I have understand the project requirement & interested to work for this project. I will start right now and I will do it within your time . Please send a message so we can discuss more & start the project. Thanks
Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA.
Hello, I am an independent, experienced excel expert. I can help with this task with a quick turn-around. Looking to hearing from you. Kind regards Rina B.