Excellent,
Thanks you so much both of you,
I am little confused about Mr.Sam's first solution due to its named ranges,
its a new knowledge to me, I will try to understand.
Thanks again both of you.
On Sun, Nov 13, 2011 at 6:13 PM, Sam Mathai Chacko wrote:
> I'd recommend keeping the method
I'd recommend keeping the method safe by relying only on the source data.
>From that echelon, I'd suggest using COUNTA to pass the column index in the
VLOOKUP argument, instead of referring to (an)other cell(s).
=VLOOKUP($I$3,$I$9:$M$13,COUNTA($I$8:I$8),0) for example can be dragged
across from co
See attached
Don Guillett
SalesAid Software
dguille...@gmail.com
From: kurikkal padinjarappalla
Sent: Sunday, November 13, 2011 4:07 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ To Set Dropdownlist in Chart
Dear All,
Could somebody help me by setting a drop down list for cre
Can be done using named ranges. Hit CTRL+F3 to find out how I named two
dynamic ranges for your data.
The ClientData for example was made like so..
=OFFSET(Sheet1!$J$8:$M$8,MATCH(Sheet1!$D$2,Sheet1!$I$9:$I$13,0),,1)
Regards,
Sam Mathai Chacko
On Sun, Nov 13, 2011 at 3:37 PM, kurikkal padinjara
