Unique combinations of records in a list
Thanks Tom your second answer seems better than the first one.
I have already come up with the first one and it would give me relative
duplacates by columns and not rows.
I will try your formula and keep you posted.
Thanks a lot anyways....
"Tom Ogilvy" wrote:
Sorry, didn't read closely enough
in F2
=IF(SUMPRODUCT(--($A$2:A2&$C$2:C2=A2&C2))1,"X","")
then drag fill down the column.
--
Regards,
Tom Ogilvy
"Leon" wrote:
I have a Excel list made of 6 columns.
Records are added to that list daily.
I want to be able to create a helper column that will show an "X" next to a
row that has 2 records, let's say on column A and C ONLY, identical to those
in previous rows.
Example:
A B C D E
John 06/18/08 $ 590.00 256 A
Jack 06/19/08 $ 700.00 300 C
Mark 06/18/08 $ 590.00 256 A
Miles 06/19/08 $1,1190.00 300 C
Jack 06/18/08 $ 700.00 256 A...............X
(Identical records on Col A AND C than row 2
Lee 06/19/08 $1,1190.00 300 C
Any help or pointer will be gratefully appreciated
|