Kashyap wrote:
yes, I did enter both as array-formulas.. result from 2nd formula was '0'


Without seeing your data, I can't say why you would be getting that result. If
you want, post your workbook on www.savefile.com and I'll take a look at it.