Thread: Match Backwards
View Single Post
  #2   Report Post  
Don Guillett
 
Posts: n/a
Default

Try taking out ,0

--
Don Guillett
SalesAid Software

"Gary's Student" wrote in message
...
I need a function like match that gives the last occurrence of a match

rather
than the first. For example, if the data in a column is:
1
2
3
4
1
2
3
4
1
2
3
4
then MATCH(2,A1:A12,0) gives 2 (the second row). I need
LASTMATCH(2,A1:A12,0) to give 10 ( the last row containing 2).

Thanks in advance for your help.

--
Gary's Student