I will try to implement both formulas but then I check for excel
calculation speed. I have many other formulas in that workbook as well,
some of which are arrays. Infact arrays slow down speed that's why I
avoid to use them. I have to implement this formula in most of my
sheets and in many rows and the reference data is also large. Array
will definitely slow down speed of calculation therefore I have to have
a substitution of this.
I will appreciate if you help me to complete that formula.

Thank you in anticipation

Regards


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=551813