Can anyone help me explain this formula in a sentance that a non-excel user
=INDEX(OldExchange,SMALL(IF(COUNTIF(NewExchange,OldExchange)=0,ROW(OldExchange)-ROW(A$3)+1),ROWS($1:1)))
OldExchange is a named range of A3:A305
NewExchange is a named range of B3:B186
Bookmarks