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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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