Hi
I am looking for macro code or excel function to compare text in a cell (A2) with the text in the previous cell (A1) and return a percentage of differences in B2, and a value of text in C2
Eg.
A1: Atlantic Ocean B1: 100% C1: New
A2: Ocean B2: -46.67% C2: Deletion
A3: Atlantic Ocean B3: +46.67% C3: Addition
A4: Pacific Ocean B4: -46.67% C4: Modification
Please help me.
Bookmarks