.RemoveDuplicates

[ry94080]

Hi all,

I'm using .RemoveDuplicates as seen below:

Please Login or Register  to view this content.

Is there a way to do this but not apply to a certain value? I don't want it to remove duplicates if the value is, "NTC".

Thanks,

[Richard Buttrey]

Not that I know of. My workaround would be to use a helper column to number the rows in ascending order but include an IF test so that all the NTC values are given a big number.
e.g.

Please Login or Register  to view this content.

Then copy the helper column and paste as values, then sort the columns using the he;per column as the key, and finally select the column of data down to the NTC values and use the Remove Duplicate functionality. Sort the data back in original order if necessary using the helper column.

Note that I believe you can only use remove duplicates in one column so I'm not sure why you specify A:D.

[daboho]

Please Login or Register  to view this content.