Nothing goes inside ROW(), although it wouldn't hurt to put a reference
to any cell in the row that the formula resides in. Given your sample
data, the formula works as is.

What error are you getting?


In article ,
"Himu" wrote:

Could you explain how I can implement this foermula. I tried to paste the
formula you provided me below, but excel gives me error. Can you tell me what
should be inside ROW(??)