Hi All,
I have a whole bunch of data (~7000 rows and 40 columns).
I have recently found that some of the row entries are duplicates. I have been searching on the boards on how to deal with these duplicates. Since I am looking for duplicate rows the usual countif stuff hasn't worked well for me. I think by using the advanced filter with the "unique records" box checked will work. The only problem is that I don't know which ones were the duplicates. I need to know this for future work.
Is there a way I can combine the conditional formating w/ the advanced filter so that the non-unique records can be highlighted??
Is there another way that is easier??
Many thanks in advance...
I have a whole bunch of data (~7000 rows and 40 columns).
I have recently found that some of the row entries are duplicates. I have been searching on the boards on how to deal with these duplicates. Since I am looking for duplicate rows the usual countif stuff hasn't worked well for me. I think by using the advanced filter with the "unique records" box checked will work. The only problem is that I don't know which ones were the duplicates. I need to know this for future work.
Is there a way I can combine the conditional formating w/ the advanced filter so that the non-unique records can be highlighted??
Is there another way that is easier??
Many thanks in advance...