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
=ArrayFormula(vlookup(UNIQUE(ARRAY_CONSTRAIN(A:A,COUNT(A:A),1)),A:D,column(A:D),1))
which would be he correct formula? It would be great if this could be done in a single formula or query.