Hi,
This is my first post here (though I have read the forums for resolving my earlier doubts).
As a sample, I have attached screenshots of the 2 sheets of data.
I am trying to find maximum value of Profits in each year 2008, 2009 & 2010 (Columns B, C & D) for each unique item (Column A) from various sheets (Company-A & Company-B).
E.g., for Item number 165, the maximum profit in 2010 is 738 and minimum profit is -34477 and so on.
I would need the results in a separate sheet for each unique Item no.
So far, I have only been able to find an approach by filtering column A for each item value, then using subtotal formula to display the maximum/minimum values of columns B, C & D in cells and then copy using vba them to a new sheet.
I am not familiar with Pivot tables.
Can anyone please guide whether there is an easy way out which I am not aware of?
Advance thanks
This is my first post here (though I have read the forums for resolving my earlier doubts).
As a sample, I have attached screenshots of the 2 sheets of data.
I am trying to find maximum value of Profits in each year 2008, 2009 & 2010 (Columns B, C & D) for each unique item (Column A) from various sheets (Company-A & Company-B).
E.g., for Item number 165, the maximum profit in 2010 is 738 and minimum profit is -34477 and so on.
I would need the results in a separate sheet for each unique Item no.
So far, I have only been able to find an approach by filtering column A for each item value, then using subtotal formula to display the maximum/minimum values of columns B, C & D in cells and then copy using vba them to a new sheet.
I am not familiar with Pivot tables.
Can anyone please guide whether there is an easy way out which I am not aware of?
Advance thanks
