ROUTE DUPLICATION FINDER

[bharath]

Sir,

Regarding route duplication,
by using help columns (FromCode&ToCode in one column and reverse in another column and using countif) it is coming,
but without using help columns if possible, pls help me

Thanks for your time

 

[vletm]

bharath
Do You have always total two rows of data?
If so then Okay or You should add more rows of data.
Could You show somewhere You needed result?

 

[bharath]

bharath
Do You have always total two rows of data?
If so then Okay or You should add more rows of data.
Could You show somewhere You needed result?

 

[r2c2]

@bharath

You can use a formula based CF rule to highlight such items. To prevent duplicate rules from being entered, you can apply same logic in custom data validation too.

For CF:

Add a rule with this
=COUNTIFS($C$2:$C$21,$C2,$D$2:$D$21,$D2)+COUNTIFS($C$2:$C$21,$D2,$D$2:$D$21,$C2)>1

and apply formatting.

I leave the DV rule for your imagination.

 

[bharath]

@bharath

You can use a formula based CF rule to highlight such items. To prevent duplicate rules from being entered, you can apply same logic in custom data validation too.

For CF:

Add a rule with this
=COUNTIFS($C$2:$C$21,$C2,$D$2:$D$21,$D2)+COUNTIFS($C$2:$C$21,$D2,$D$2:$D$21,$C2)>1

and apply formatting.

I leave the DV rule for your imagination.

YES....THANKS A LOT