Hi All,
I'd like to extract some data from a pivot table if a cell matches another cell. For example, if a particular company offered sale, I want to list all the years they had sale in. I have a pivot table where the Company numbers (titled 'Company') and years (titled 'year') are in the Report Filter section.
Then, in an excel tab I have the following:
Company Year Sale 1 sale 2 no sale 3 sale
So, in column 2 I would like to have a formula/function stating, if Column 3 says sale then copy the years for company in column 1 from the pivot.
So, I'd get something like below:
Company Year Sale 1 2012, 2013, 2014 sale 2 no sale 3 2014, 2015 sale
Bookmarks