View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
 
Posts: 1,180
Default find 2nd occurence

This formula can give you any nth occurrence:
=INDEX(Code,SMALL(IF((Fix R=Start)*(Fix R<=End),rown),VALUE(BinA C)))
For an Excel 2007 spreadsheet example see:
http://www.savefile.com/files/1891070