Dear All
i have a file where i have 3 databases Actual sales for 2014, 2015 and BU 2016, they are not similar but in all three customer name and brand names are same and based on these two elements of my database i have to make a unique list. i need a formula which can bring customer on a new sheet which are present in all the three databases and they build a data based by Month by brands
Customer name - Actual Jan 14 - Actual Jan 15 - BU Jan 16
till december for all three years which can show how much a customer bought in 2014 and 2015 by brands and what he is going to buy in 2016 by brands.
i hope i have cleared my requirement and for reference i have attached a file for your review.
look forward to your help on this.
Kind Regards
i have a file where i have 3 databases Actual sales for 2014, 2015 and BU 2016, they are not similar but in all three customer name and brand names are same and based on these two elements of my database i have to make a unique list. i need a formula which can bring customer on a new sheet which are present in all the three databases and they build a data based by Month by brands
Customer name - Actual Jan 14 - Actual Jan 15 - BU Jan 16
till december for all three years which can show how much a customer bought in 2014 and 2015 by brands and what he is going to buy in 2016 by brands.
i hope i have cleared my requirement and for reference i have attached a file for your review.
look forward to your help on this.
Kind Regards