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