In excel would have two columns with same numbers but different special characters. Would like to have formula that compares both columns, disregards the special characters and highlights the numbers in each column when they are in both columns or vice versa. So I can easily see the ones that are not in both columns. Example of both columns here.
Column A has numbers with double quotes, Column be no quotes but separates the numbers with semi colon. The columns do not match one to one they could be in any row in the column as you see here this row does not match but the value of the first one is in the column B also.