Good day
I am have trouble with the match function on the attached sheet. I have number of duplicate in column B and when I match it returns the value of the first duplicate in the range instead of going to the next and so forth. (i, cell G20 matches row 27 and the cell G21 should match row 28).
you help will be appreciated
I am have trouble with the match function on the attached sheet. I have number of duplicate in column B and when I match it returns the value of the first duplicate in the range instead of going to the next and so forth. (i, cell G20 matches row 27 and the cell G21 should match row 28).
you help will be appreciated