Thread: match nth occurence
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default match nth occurence
On Thu, 26 Feb 2009 11:03:43 -0000, "Max Scott" wrote:

Hi

I can use match to find the first occurence of a value in a list - how can i
find the 2nd, 3rd, nth value in a list? I'm using excel 2007 btw.

Thanks

Max


Take a look at the Arbitrary Lookups section on this page:

http://www.cpearson.com/excel/TablesAndLookups.aspx

--ron
Reply With QuoteReply With Quote