0

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.

  • Please give a read to the How to Ask page. It is also helpful when you include a link to a sample sheet. – marikamitsos Nov 15 '18 at 12:36
0

Try this instead:

=ArrayFormula(IFERROR(VLOOKUP(UNIQUE(A:A),A:D,{1,2,3,4},FALSE)))

Your Answer

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.