Dear Friends,
I need a help to solve a problem.
I have a worksheet in which I have customer data (currently active). The ANO field is the unique code for each customer.
In other three sheets, QLY1, QLY2, QLY3 some sales stats (of customers) are there.
Now, I need to cosolidate the customer data with QLY (all 1, 2, 3) statistics together in a CONSOLIDATED sheet.
Besides, I need to count no.of QLYs in which the concerned ANOs appear.
I have attached the sample file for your kind reference.
Thanking you and in anticipation,
acsishere.
Bookmarks