Hello Guys
i am stuck with the syntax of the formula
this works fine
but i want the above formula to be dynamic and i do not know what the proper syntax will be, i want A:J to be replaced to A:1Col and match (O2) to be replaced with match(cells(i,1Col+5))
Thankyou guys