Forum Discussion

pacificstorm82's avatar
pacificstorm82
Copper Contributor
May 23, 2019
Solved

extract specific data from a list

Hello, =IFERROR(INDEX(Input!C:C,MATCH(0,IF($I$2=Input!A:A,COUNTIF($I$2:I3,Input!C:C),""),0)),"") I am using this array formula to sort a list of many different serial numbers into a list containing...
excel
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    May 24, 2019
    I am replying via mobile phone so I can’t test this formula in D3, copied down rows:
    =IFERROR(INDEX(B$3:B$100,
    AGGREGATE(15,6,
    1/((A$3:A$100=D$2)*
    (LEFT(B$3:B$100,2)=D$1)*
    (COUNTIF(D$2:D2,B$3:B$100)=0))*
    (ROW(A$3:A$100)-2),1)),””)
    The foregoing formula assumes that the text “AB” is stored in D1 to avoid hard-coding thereof.
Twifoo's avatar
Twifoo
Silver Contributor
May 23, 2019
To enable formula testing, please attach your sample file.

Resources