Hi,
I have a large data seet. I want to remove any rows for which the ID number (listed in the first column) has previously appeared. If this works correctly I expect about 40% of the entries to be removed.
However, when I use Data->Filter->Standard Filter-> Option-> Remove duplicates ALL my data points are being removed.
I’m not sure why this is happening. I would include the screenshot or attach the data but I do not correctly have enough karma points.
Thanks