+ Reply to Thread
Results 1 to 8 of 8

First occurrence of each item

  1. #1
    Registered User
    Join Date
    11-16-2012
    Location
    hyderabad (india)
    MS-Off Ver
    Excel 2010 32-bit
    Posts
    47

    First occurrence of each item

    Dear all,

    i've a list of movie names with their date of telecast for the last 2 years. Each movie is repeated more than 1 times in this period. I Need to filter each movie with their first date of telecast.

    Please give an idea how to find it.

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: First occurrence of each item

    Hi

    Use the find part of find and replace that should do it for you or insert a table and filter on movie name that will find all instances of the movie.



    Chris
    Click my star if I helped Thanks

  3. #3
    Registered User
    Join Date
    11-16-2012
    Location
    hyderabad (india)
    MS-Off Ver
    Excel 2010 32-bit
    Posts
    47

    Re: First occurrence of each item

    Thanks for the swipt response Chris,

    But i have Large no of movies. I need summary data with list of movies & their first date of telecast.

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: First occurrence of each item

    if you upload your work book or a sample i think it could be done with index and match
    The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
    <--- If a post helps hit the star

  5. #5
    Registered User
    Join Date
    11-16-2012
    Location
    hyderabad (india)
    MS-Off Ver
    Excel 2010 32-bit
    Posts
    47

    Re: First occurrence of each item

    Ok

    Here's the file.
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: First occurrence of each item

    try this (btw i removed all your extra spaces off your titles as index and match could fail if there are more spaces in 1 than the other)


    sample data.xlsx

  7. #7
    Registered User
    Join Date
    11-16-2012
    Location
    hyderabad (india)
    MS-Off Ver
    Excel 2010 32-bit
    Posts
    47

    Re: First occurrence of each item

    Thank you Twiggywales,

    Thats really helpful.

    Just for info, i found another solution by applying vlookup.

    Thank you very much guys for your valuable advises.

    Regards,
    Raja.
    Attached Files Attached Files

  8. #8
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    wales
    MS-Off Ver
    Excel 2007
    Posts
    964

    Re: First occurrence of each item

    glad you got it solved.

    remember to mark the thread solved

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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