Find out the same 3-5 symbols in cells and mark cell
Posted on 2014-04-06
I need to find the same 3-5 symbols or signs in 1 or 2 columns (but as one whole string), and mark them as duplicate in another column,
or just mark them with color, or maybe extract that same cells in other column.
I want to extract, mark with color or duplicate that cells (A1, A2) because they have the same "w34-5" symbols in one whole string, or "7890" not (A3), because he don't contain 3-4 symbols in 1 string just 2 "zw". Don't care if I have double check's same cell like in A1 and A2.