Finding replicate data accidentally entered into a worksheet
Hi,
I have entered data into a column. there is over 1,000 entries but I have mistakenly entered repeat data without knowing and I now need to filter out the replicate data without sifting through it manually- is there a way?? |
Finding replicate data accidentally entered into a worksheet
Chip Pearson's web site has several pages dealing with duplicates:
http://www.cpearson.com/excel/topic.aspx Scroll down to the D's, and check out the pages on duplicates. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "Fran" wrote in message ... Hi, I have entered data into a column. there is over 1,000 entries but I have mistakenly entered repeat data without knowing and I now need to filter out the replicate data without sifting through it manually- is there a way?? |
All times are GMT +1. The time now is 12:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com