[wilmarjr]

I work with worksheets with 6.000 rows ou more, sometimes I have to delete duplicate rows. How can I delete all those duplicates at once? Or has any formula that make easy to delete??
Because right now I have to go line by line and this is take too long to do!!

Thanks for everyone that will try to help me!

[Advertisements]

Hi,
i too deal with large data sets and have a bit of exp with Excel, however to help i need to know a few more things...can you tell me does each row have a unique heading, how many columns are you dealing with in your spredsheets? If your dataset is not private, could you provide a screen shot, if your data is private could you supply an example of your spreadsheet??

Have you tried autofilters and pivot tables? What about an IF statement written into a macro?

It's easier to help if i know what your playing with.
cool
J.

[jwal001]

Hi,
i too deal with large data sets and have a bit of exp with Excel, however to help i need to know a few more things...can you tell me does each row have a unique heading, how many columns are you dealing with in your spredsheets? If your dataset is not private, could you provide a screen shot, if your data is private could you supply an example of your spreadsheet??

Have you tried autofilters and pivot tables? What about an IF statement written into a macro?

It's easier to help if i know what your playing with.
cool
J.