thank you so much ASA.
thanks for all your help.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not
-expansion benefit.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Avinash
Sent: Saturday, March 24, 2012 8:42 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Arry Formula help
Dear Asa,
Thanks A lo it
>
> The "A" at the end of the formula indicates that you want the result
> returned in a horizontal array. The default is for a vertical array (or
> you can specify "V"), which is what you need since you have a vertical
> range of cells. The formula should change to
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Avinash
Sent: Friday, March 23, 2012 7:34 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Arry Formula help
Dear Asa,
thanks for your help and using your technique i've found
criteria range, but can handle
any combination of sophisticated criteria.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Damimkader S. Meeran
Sent: Thursday, March 22, 2012 10:40 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Arry
Hi,
I checked the VBAVlookup custom function, it is looking up using usernumber
and the layout on the Txtlist sheet. If this is slowing down the
performance of the application, I would recommend creating a column which
concatenates the usernumber and layout column on the "txt list" sheet and
o
