Hi everyone, total newbie here!
So basically, I have three sheets of data and want to pull a set of unique values between the three and put them in a summary sheet.
There are essentially a set of 4 values in each row, but all I care about is the unique set of product name and age.
For example,
there could be a set with (Apple,42) and (Apple,15); because the ages are different, they would be listed in the summary sheet.
Here is an example of how it would look.
Example.xlsx
Don't worry about the Qty on the summary page; I already have a formula that sums up the quantities from each sheet based on the age on the summary page.
Also, anyone think it's possible to do this with a pivot table? I couldn't figure out how to include the product name, ages, and quantities.
Thanks for any help or tips!
Bookmarks