Finding exact matches through a lot of data?

Sheet 1, i have a lot of numbered data, rows upon rows. I generate an every day report that consist of different data but also sometimes the same numbered data will appear from the previous day. To avoid doing double the work, is it possible to copy/paste the new data on a column in Sheet 2, to tell me if there is a duplicate value from Sheet 1? I want to spot the duplicate value and delete that specific row.



For example:

Column 1:
831928416265023
559239161521821
056426660406591
253129719663617
538155540124841
928688530387906
085041567770440
236447784263130
081055086773275
997315600108436
017136299595962
165284476511611
984448030005405
377183430727835
644857040027393
044181970024143
841829272539679
494273510230822


The next day i generate the report, this is my results:

997315600108436
494273510230822
841829272539679
165284476511611
377183430727835
236447784263130
468399715132794
081055086773275
056426660406591
538155540124841
085041567770440
345121573692024
240531315083465
298064015878194
878280715042783
380365767016590
820389161023513
820389161023520
745209363661095
522242515032085
681312886030620


As u can tell the following numbers below, is duplicated:

056426660406591
081055086773275
085041567770440
165284476511611
236447784263130
377183430727835
494273510230822
538155540124841
841829272539679
997315600108436


I had to go through each one by one, which is time consuming to find a match. Is there any other easier way? Thanks!!!

I would recommend playing with the 'remove duplicates' tool. It can be found in Data > Remove Duplicates. You can specify which columns you want to search within a selection and how to select and remove the duplicates. To protect your data, I would make a copy of it until you find out if this will work for your specific situation, and how you can best use the tool.

Aloha,

I am also trying to accomplish something similar but rather than removing duplicates in a column of data, I want to identify those duplicates and move them to another sheet in my workbook. I have a list of guests at a hotel and I am trying to identify reservations with the same name or same e-mail address or same frequent guest account number. I need to identify these duplicates so I can be sure that I assign connecting or adjacent rooms (as these are likely family members traveling together with multiple reservations).

I am programming macros in VBA and the best that I could come up with is a subroutine that first sorts the columns ascending and running a loop that compares one of the cells to the next cell below in the column.

However, I haven't been able to get this to work -- the macro crashes Excel every time I execute this search. I am wondering if any of you have ideas on how to accomplish this kind of search to look for duplicates within the same column (again to identify them, not to remove them).

Mahalo,

Andrew