+ Reply to Thread
Results 1 to 3 of 3

Index and Match 2 criteria 1 unique value

  1. #1
    Registered User
    Join Date
    02-24-2012
    Location
    Moon
    MS-Off Ver
    Excel 2010
    Posts
    3

    Index and Match 2 criteria 1 unique value

    Hello,

    I am trying to match sales records (day + product) and return client, but some sales overlap.

    This returns me the same client for two different entries.

    I am sure there is some formula to avoid such thing or to return unique value. Although I found some array formulas on Google wasn't able to apply for my kind of data.

    I have attached Excel file to clear things up.

    I am using Excel 2010

    Thanks for help

    edited. I'm really sorry, uploaded wrong file . Now it's ok
    Attached Files Attached Files
    Last edited by kosmonautas; 05-17-2012 at 03:15 AM.

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Index and Match 2 criteria 1 unique value

    hi kosmonautas, sorry i dont know which worksheet are we supposed to look at & cant understand the language headers of it too. hope my eg solves your problem
    Attached Files Attached Files

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    02-24-2012
    Location
    Moon
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Index and Match 2 criteria 1 unique value

    I will try to apply your solution and return with results . Thank you.

    edited.

    I am still to learn about an array formulas and wasn't able to apply your to my data :/
    Attached Files Attached Files
    Last edited by kosmonautas; 05-17-2012 at 04:00 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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