+ Reply to Thread
Results 1 to 4 of 4

Index match query

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    UAE
    MS-Off Ver
    Excel 2007
    Posts
    24

    Index match query

    Hi Good day to all

    I have a scenario here 2 worksheet in a file an employee record. Column E where my my index match reside to look for the match in p2 timesheet where some employe have duplicate. I want to show the duplicate in June 2012 sheet? in somehow my formula was only to show 1 row at a time. It is possible to show the other row in duplicate?

    Sample file attached for reference

    Thanks a lot
    Attached Files Attached Files

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Index match query

    In column F of June 2012 sheet, use

    =COUNTIF('P2 TIMESHEET JUN 2012'!B:B,D4). This will show you how many times the said name is repeated.
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Index match query

    It would be easier to understand your question if you filled in your expected results in the sample sheet so that we can see what you're trying to achieve.

  4. #4
    Registered User
    Join Date
    07-04-2012
    Location
    UAE
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Index match query

    Thanks for the help guys. the only thing i want is to add in next row (june 2012) the 2nd item (duplicate) i will found in P2 timesheet worksheet. Hope that is possible.

    thanks again
    Attached Files Attached Files

+ 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