When in a spreadsheet two consecutive rows have identical contents in columns B to E, I need a formula that inserts “DELETE” into the empty cells of column A:
With what formula can I achieve this?
“DELETE” for both row or for second and other?
By the way, what about Remove Duplicates or Remove Duplicates Fast?
“DELETE” would be necessary, in the above example, both in A34 and in A35.
(The two extensions you link to may prove useful in a different project of mine.)
This is exactly what I need. Thank you!