Thread
:
find 2nd occurence
View Single Post
#
7
Posted to microsoft.public.excel.misc
Herbert Seidenberg
external usenet poster
Posts: 1,180
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
Reply With Quote
Herbert Seidenberg
View Public Profile
Find all posts by Herbert Seidenberg