Excel Help - Match Function
Posted: Tue Nov 24, 2009 12:31 am
Can anybody help me with a problem I have with the match function in Excel.
If you have a list of numbers in a column and you wanted to find the previous occurence of a cell's data you would use something like
=match(b2,b3:b100,0)
Does anybody know how to find the next previous occurrence in the list
Rgds
RD
If you have a list of numbers in a column and you wanted to find the previous occurence of a cell's data you would use something like
=match(b2,b3:b100,0)
Does anybody know how to find the next previous occurrence in the list
Rgds
RD