I need some simple excel formula to do the following. I have two columns of data, all numbers that are 10 digits long each. I want to filter the second column and highlight any cells that match a number from the first column. For example: Column A ---------- 1234567890 1111111111 6948509395 Column B --------- 1234561234 0000000000 6948500000 2092045930 1382094904 3509234092 I would then filter column B so that if the first 6 digits of column B matched at least one number in column A it would be highlighted. The numbers from column B that would be highlighted would be 1234561234 6948500000 The other numbers have no matches and would not be highlighted. If this isn't clear please let me know