You are welcome..Kalyan.
I have used the array functionallity to grasp the desired results and given
you two drop downs, which you can utilize for your desired result
selection. You can also add more drop downs as per your interest in the
similar fashion.
I would recommend you to learn some mate
Please find attached solution.
Regards,
C.G.Kumar
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Kal xcel
Sent: Wednesday, August 18, 2010 6:49 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Etracting sales data as per desired
Hi Kalyan,
Looks like you need to repeat the same formula twice in the same cell.
Once with Distributor and once with Super stockist. Ya, do not forget
to adjoin the formula's with plus in between. ;)
I don't understand one thing though, why don't you use Pivot. Its
really easy with that.
Anyways
Thanks experts.
But I need the sale data of "Distributor+super stockist" only. not the
whole. I have done for one customer group="Distributor, by Sumifs function,
but when its matter of more than one customer group..sumifs not working
properly.
Please help.
Thanks in advance
Kalyan
On Wed,
