Hi guys,
Looking to perform a match within just one column (B1:B1400). I am basically trying to see if the content in a row matches any in the column above. But i want to exclude the row i have the formula in from the search.
eg. in cell c1 i have the formula "=MATCH (A1, B1:B1400, 0)" , which takes the value in A1 and returns the row number it finds a match in....except i want the to exclude ROW 1 from that search.
Does this make sense? Seems simple enough but unable to figure it out. Pls help!
Cheers
Looking to perform a match within just one column (B1:B1400). I am basically trying to see if the content in a row matches any in the column above. But i want to exclude the row i have the formula in from the search.
eg. in cell c1 i have the formula "=MATCH (A1, B1:B1400, 0)" , which takes the value in A1 and returns the row number it finds a match in....except i want the to exclude ROW 1 from that search.
Does this make sense? Seems simple enough but unable to figure it out. Pls help!
Cheers
