1

There is a column with many duplicate values, I want to filter out all duplicate values but still keeping a single value among the duplicates. For eg -If my column has

[a,b,a,a,a,b,c,c,d]

then I want result to be like -

[a,b,c,d].

How can I do this?

UPATE - I don't want to remove all duplicates , I want to get one value of each duplicate.

harsh atal
  • 411
  • 6
  • 16
  • Possible duplicate of [Delete duplicate rows in calc?](http://stackoverflow.com/questions/22511660/delete-duplicate-rows-in-calc). See also http://askubuntu.com/a/502897/20661 – tohuwawohu Jun 22 '16 at 12:13

1 Answers1

0

Solved by using IF() formula in another column

harsh atal
  • 411
  • 6
  • 16