not able to fix row(a:a) in formula

[jpbisani]

formula error in row(aa).xlsx

I am not able to mention row(2:2) in formula. Where row(2:2) starts, the next row should be row(3:3) but in second instance of row(2;2), i am not able to bring row(3:3). the red mark colum are in formula and have mistakes, while the answers should be as shown in green color. Thank you in advance.

JPbisani

[dilipandey]

Hi JPbisani,


See the attached file where I have corrected the formula and results are coming as expected. thanks.
formula error in row(aa).xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[jpbisani]

Hi DiliPandey,

I appreciate, value and admire your immediate response. Thank you very much.

Regards

J P Bisani

[dilipandey]

You are welcome Bisani... Cheers

Regards,
DILIPandey

<click on below 'star' if this helps>