formula find duplicates in diffenet columns

[akdom]

Crystal Reports Version 10

Just started to learn CR. I don't know if i should use a formula, or do a group to solve the following problem. Please show me step by step. Appreciate it.

--------------------
ID  COL1 COL2
001 10   7777
002 9999 7777
003 7777 20 
004 9999 30
005 40   9999
006 50   50
--------------------

I need to make a group which have the rows that have duplicates BOTH in COL1 and COL2. So I guess i need a formula which return a boolean when find a match in the other column.

Could you show me how to write a formula so
This is the output should look like:

--------------------
ID  COL1 COL2
001 10   7777
002 9999 7777
003 7777 20 
004 9999 30
005 40   9999
--------------------

(in these entries, either 1 or both fields have duplicates in the other column)

 

[dgillz]

Please define "duplicate". The value 7777 is in both columns, but never on the same record. Do you consider this a duplicate? Or do you mean only where col1=col2 on the same record?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[lbass]

ID 006 also meets your criterion, so you need to provide more explanation as Dgillz suggests.

-LB

 

[akdom]

I need to extract out all rows that have 7777, no matter this number is in COL1 or COL2.

If a number apear more than once in the two columns, I need to see it.


Thank you for all your help......

 

[lbass]

Then why didn't you also show ID 006 in your desired results? 50 is in both columns.

-LB