Forum Discussion

certavi's avatar
certavi
Copper Contributor
Feb 22, 2020
Solved

INDEX MATCH function, avoid duplicate returns

Hi everyone!   I'm working on a sheet for work. I am on my last task and can't seem to figure this one out. I'm hoping someone can help:   I have a data sheet with all the data. In my current she...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 22, 2020

    certavi 

    If you are on Excel with dynamic arrays that could be

    =UNIQUE(FILTER('Horse data'!B2:B100,
  (I$13='Horse data'!C2:C100) * ($K$13='Horse data'!D2:D100)
))
Sean_Sangreal_Ang's avatar
Sean_Sangreal_Ang
Copper Contributor
May 08, 2023

byundtHello, apologies but where is the paperclip icon? It's not visible on my end, so i don't see where i can attach files. I've looked through every single icon, and none indicates an option to attach files.

 

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 08, 2023

Sean_Sangreal_Ang 

Attach file icon is not available for all users, have no idea why so. Alternatively you may share the file on OneDrive, GoogleDrive or so.

  • byundt's avatar
    byundt
    Brass Contributor
    May 08, 2023
    Sergei,
    Thanks for that tip.
    Brad

Resources