Removing unwanted elements - Automation/Simple logic

Hello,

I want to find a way to instigate the following rule against all selected cells: If the cell to the right of the current cell is the same, delete the contents of the current cell.

So the tables below are essentially what the before running and after running this rule.

BEFORE

ONE	ONE	ONE
TWO	TWO	TWO	TWO
THREE	THREE	THREE	THREE	THREE

AFTER

		ONE
			TWO
				THREE

IS delete, delete the cell and move the other cells to the left, or clear the values

is line 1 just one in column A, or just one in column 3?

is there only ever one value on each line, so it is the last value?

thanks

Dav

Nothing is moved, only deleted if a duplicate exists in the adjacent cell to the right. The result will be that only elements furthest to the right will remain. Sorry, the second table is a little out of alignment.

Please Login or Register  to view this content.

Thank you. That works perfectly