I have to keep a list at work of about 1200 customers. There is a customer number and an order number. Some of end up getting put on the list twice. Right now I just sort the list and look for duplicates but is there anyway to have Excel pick them out?
2006-07-19 04:35:44 · 3 answers · asked by rishathra7 6 in Computers & Internet ➔ Software
I've played with the find option but I'd have to find 1200 different numbers which is just as slow as what I'm doing now.
2006-07-19 04:40:00 · update #1
I'd love to use Access. However, powers higher then me decided that Excel was the way we were gonna go on this. I'm not the one who enters most of the data into this thing, I'm just the one who gets to clean up the mess. *sigh*
2006-07-19 04:47:39 · update #2
Well, I have always used the Data Sort and Filter functions to find duplicates in Excel.
Access is the way to go to get them sorted in to their own set. You can make a Query on the Table, requesting duplicates, based upon a particular Field (or even group of fields) and they will show you only the dupes. You then would have to go through and delete the ones you wanted by hand.
Once you get to high numbers of records it really pays to consider Access and it can be a lot of fun. There are great books out there to help you learn it - I am all self taught.
Peace!
2006-07-19 04:41:57 · answer #1 · answered by carole 7 · 2⤊ 0⤋
You can use the Find function, and instead of clicking Find Next, click Find All, and it will show you all the instances of that keyword.
2006-07-19 04:38:27 · answer #2 · answered by PiccChick12 4 · 0⤊ 0⤋
re-sort by the column that has the dupes, then you can find them easily enough
2006-07-19 04:42:32 · answer #3 · answered by Anonymous · 0⤊ 0⤋