Forum Discussion

Deleted's avatar
Deleted
May 21, 2019
Solved

Comparing lists

Hi ... Would appreciate help with the following query.   I have two lists of names as follows:          List A                                           List B        Smith                     ...
excel
  • Twifoo's avatar
    Twifoo
    May 21, 2019
    To create a distinct sorted list, write this formula in B2 and copy it down:
    =IFERROR(LOOKUP(2,
    1/(COUNTIF(A$2:A$100,”>=“&A$2:A$100)=MAX(INDEX(COUNTIF(A$2:A$100,”>=“&A$2:A$100)*(COUNTIF(B$1:B1,A$2:A$100)=0),0))),
    A$2:A$100),””)
Moyna Good's avatar
Moyna Good
Copper Contributor
May 21, 2019

Deleted 

 

Hi - have you tried 'Data' ' Remove Duplicates'?

Resources