Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Oct 21, 2022
Solved

How to compare two ranges of names?

if I have two ranges of name Range 1 F11:F22 Range 2 H11:H15 I want to compare these two ranges such that the result should appear only the name of range H11:H15 which are not existing in range F1...
  • HansVogelaar's avatar
    Oct 21, 2022

    ajl_ahmed 

    =FILTER(H11:H15,ISERROR(MATCH(H11:H15,F11:F22,0)),"")

     

    or

     

    =FILTER(H11:H15,COUNTIF(F11:F22,H11:H15)=0,"")

     

    Remark: it will also return Name12, since the range on the left has Name 12 and the one on the right has Name12 without a space.

Resources