Spiga

Excel: Find the nth Occurrence of a Value



Note also that this extra column can be hidden from view to make for
less clutter. If you have not already guessed, we now simply use a
standard VLOOKUP, or INDEX/MATCH to obtain the occurrence we want, for
example;

=VLOOKUP("Bill 3",$A$1:$C$22,3,FALSE)

Would yield a return value of "Bill # 3"

Find the Nth Occurrence of Specified
Value Custom VBA Function

The custom function/formula below was written in Excel 2003 and may not
work in earlier Excel versions.

The custom function/formula can now be used like shown below 

=Nth_Occurrence($B$1:$B$22,"Harry",3,0,1)

The syntax is

=Nth_Occurrence(range_look,find_it,occurrence,offset_row,offset_col)

This content was originally posted on http://officeresources.blogspot.com/ © 2008 If you are not reading this text from the above site, you are reading a splog

0 comments: