I am trying to remove duplicates from my Google spreadsheet file.
Here is an initial table example
A B C D HelloWorld1 2 6 41 HelloWorld1 4 3 5 HelloWorld2 6 46 6 HelloWorld2 2 4 4 HelloWorld2 5 6 2 HelloWorld3 9 3 5
It should remove all duplicates but leave the fist entry as follows:
A B C D HelloWorld1 2 6 41 HelloWorld2 6 46 6 HelloWorld3 9 3 5
I have tried different formulas and techniques, however I haven't got them working. Sorting is not suitable, because I need to leave the same order of rows.
I have tried the following formula for removing, based on the first column. However, I got
An array value could not be found
which would be he correct formula? It would be great if this could be done in a single formula or query.