I think the main issue was the very large lookup ranges for that formula and
other formulas, but you are right that a built-in function solution would
probably be faster.
I did not analyze what the VBA function was doing, but another powerful
lookup function is DGET. It needs a separate criter
Avinash my friend,
My pleasure.
As to the formula for C2. You should get the same result for formula #1 and
formula #3. The downside with those is that they refer to the
Responsibility column using A1 notation, which might lead to errors later.
The formula I provided uses notation only availa
Dear Asa,
Thanks A lo it works well. Both the formula and the results
are working fine plus it is not time consuming.
thank you very much .
but i have just one question if i put additional data in to the table then
also it will work as it is or do i need to rebuilt all the form
-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
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