Is there any formula to get output to automate salesperson name in worksheet attached ?|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hello Mitul,

The purpose of using Pivot Table is to structure the data as you want to present it, often by using graphs.
Due to the layout of the table you have created there is no easy way to continue with your approach. Either you continue as you have started, but you will not have any dynamic update in your list of maximum sales per month and year.

In attached file I have copied your Pivot Table to another sheet, named MaxSales. I re-arranged the Pivot Table so it gives (in my opinion) a better view of what I want to show, namely which salesperson who sold the most per device, month and year. Whenever I add more data this Pivot Table will be updated accordingly, no need for manual extra work. For extra visibility I also added a formatting rule so that the maximum sales is highlighted in green.

If you want to continue create a separate list, then I suggest you don't use the Pivot Table as the data source for your lookups, better then to use the raw data. I know this is not an answer to your question, rather an example of how you can use another approach to achieve the same.

Br,
Anders