Excel – how to extract unique list from column

Use this formula =INDEX($A$2:$A$5,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$5),0,0),0)) This formula would go into B2:Bn  (the key is the $B$1:B1, is an expanding range as it is copied down, to check against what is already in column B against source list in column A. Twitter Pinterest Reddit Google+

excel – Find if value in column A contains value from column B?

BLUF:You could try this =IF(ISNA(VLOOKUP(,,1,FALSE)),FALSE, TRUE) -or- =IF(ISNA(VLOOKUP(,,1,FALSE)),”FALSE”, “File found in row ” & MATCH(,,0)) =IF(ISNA(VLOOKUP(,,1,FALSE)),FALSE, TRUE) Source: excel – Find if value in column A contains value from column B? – Stack Overflow Twitter Pinterest Reddit Google+