check for double data

V

VILLABILLA

Hello everyone!

I have a list of data where with every new input a new row is create
in my list, this is done with the use of a macro.
The list exists of several columns.
I want to keep track of double inputs.

Here is how it looks like

A B C
1 APPLE 15/6/2004 SMITH
2 PEER 15/6/2004 PETER
4 PEER 17/6/2004 PETER
5 ORANGE 06/7/2004 JOHN
6 ORANGE 06/7/2004 JOHN
etc..

As you can see in the list, I have a double input on row 5 and 6.
I would like to see it in a big list of data when two rows are th
same. Any kind of solution would be very welcome...

Regards
 
D

Dave Peterson

If you're going to eliminate the duplicates, ignore this response--just use
filky's.

But if you want to see the list of duplicates....

I'd use two helper columns filled with formulas:

In the first helper column (say column E):
=a1&char(1)&b1&char(1)&c1&char(1)&d1
(as many as I need)

In the next column (say F), I'd use this formula (written for F1 and copied
down):

=countif(e:e,e1)

The apply data|Filter|autofilter, custom filter to show the rows with values
greater than 1.
 
Top