View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
peyman peyman is offline
external usenet poster
 
Posts: 189
Default the Last occurance

Hi everybody,

I need to now how I can get the last Row number of last occurance of an item
in a list, for example:

row item
1 A
2 B
3 D
4 A

I want a formula to return me row number 4 after looking up A.
Any hints,
thanks.