On Thursday, May 19, 2016 at 12:44:06 PM UTC+5:30, Claus Busch wrote:
Hi Nitya,

Am Thu, 19 May 2016 00:10:56 -0700 (PDT) schrieb Nitya Satheesh:

Thanks for the reply, but It's showing me '-' in all the cells. it is not showing me any values in the correct positions. is there anything i have to change?

it is an array formula. Did you enter it with CTRL+Shift+Enter?


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Hi claus,
Thanks! I just tried that and it worked!

Nitya