Search:

Type: Posts; User: LionGeo; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Returning multiple results match with no duplicates

    Thanks for all the help, it finally worked. Sorting out the data to be ascending got it to click together.
  2. Re: Returning multiple results match with no duplicates

    =IFERROR(INDEX($C$2:$C$15000,AGGREGATE(15,6,(ROW($C$2:$C$15000)-ROW($C$2)+1)/($A$2:$A$15000=$E2),COLUMNS($A$1:A$1))),"")

    Same Formula just increasing the ranges the for the amount of data
  3. Re: Returning multiple results match with no duplicates

    Apologies, It is just showing up blank.

    When I change the reference being matched to the same as the first reference being checked then it works perfectly, anyway else and its blank.
  4. Re: Returning multiple results match with no duplicates

    As I dont know how to edit posts I wanted to add/Clarify.

    I have a specific list of names/reference numbers, and I need to get the results for those names/references. So I would need it to lookup...
  5. Re: Returning multiple results match with no duplicates

    Hi and thanks for the response and welcome!

    Tried the formula above and it did not work, does it make any difference if I noted its Excel 2016?
  6. Returning multiple results match with no duplicates

    Hi all,

    New here and would really like some help with a formula.

    (Table created for clarity) I would need the formula to firstly find the persons name in the first Row, once it has been found...
Results 1 to 6 of 6