Problem with removing duplicates

[zubair99]

Hi,
I have a large data worksheet. I want to remove duplicates from it but problem is found that duplicates everything but category are different.
if I un-select category colum from function remove duplicates it will deleted all
duplicates which are different category ?

worksheet link
https://copy.com/rVvmJz0zED91WMTQ

 

[anglais428]

I cannot fully understand what you mean.
If you only want to delete based on a few columns, I would suggest you simply create a helper column and add together your existing columns in it (e.g. =A2&B2&C2).
Then you can proceed to remove duplicates.