In Workbook "Sheeta" match 2nd-row cell data with below cells in same column one by one and show the result in "Result(After Sheet)".
If cell data: from row 2 matches below cell data: keep the value/data in bracket
If cell data: from row 2 mismatches below cell data: concatenate value/data with double semicolon like this "(ay::xy)"
The original data range is different. Shown in image rows from 1 to 6.
Bookmarks