Results 1 to 6 of 6

How to Return the row# of the 2nd Occurrence using MATCH( ) Function?

Threaded View

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    Cairo, Egypt
    MS-Off Ver
    Excel 2010
    Posts
    9

    How to Return the row# of the 2nd Occurrence using MATCH( ) Function?

    Dears,

    I know how to use MATCH() Function to return the row number of which the look-up value occurs, what I need to do is to return the row number of the second occurrence of this look-up value, is there any way to do that?
    Last edited by htawfik; 02-07-2014 at 02:16 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 10-27-2010, 08:05 PM
  2. Return First Occurrence
    By ComradeBT in forum Excel General
    Replies: 12
    Last Post: 07-29-2010, 03:15 PM
  3. vlookup to return the nth occurrence
    By niyrho in forum Excel General
    Replies: 2
    Last Post: 07-29-2008, 02:53 PM
  4. Match Each Numeric occurrence and Return Individual Rows of Data
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-13-2005, 12:05 AM
  5. [SOLVED] Match Last Occurrence of two numbers and Return Date
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-05-2005, 08:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1