Highlighting Data Exceptions
 

Hi,

Hope you can help. Had a search around but couldn't quite find the
answer to this problem within the newsgroup.

I have a set of data, spanning just over 60,000 records in Excel.
This is two columns (UniqueName and LineItem). I need to be able to
show that the UniqueName field doesn't appear twice against any
LineItem.

Therefore the formula would need to show any examples where different
LineItems contain the same UniqueName. I've enclosed a set of data
below to 'test' this on.

UniqueName Line Item
IR0000027446-10842 OR11062
IR0000027512-15298 OR15648
IR0000027532-14440 OR16882
IR0000027627-20023 OR16677
IR0000027632-21155 OR19324
IR0000027682-22227 OR21586
IR0000027829-28170 OR28501
IR0000027842-25719 OR23127
IR0000030260-7501 OR4117
IR0000030435-15602 OR13148
IR0000027842-25719 OR132
IR0000030478-16840 OR18805

So in the above data set it would need to highlight that
IR0000027842-25719 appears against OR132 + OR23127

Appreciate your help on this.

Thanks, Al.

Highlighting Data Exceptions
 

Hi,

If unique name really is unique then maybe you can simply look for
duplicates in that column. If so select the column with A1 as the topmost
cell and then
Format|Conditional format|Formula is
=COUNTIF($A$1:$A$12,A1)1
Pick a colour and click OK

Mike

" wrote:

Hi,

Hope you can help. Had a search around but couldn't quite find the
answer to this problem within the newsgroup.

I have a set of data, spanning just over 60,000 records in Excel.
This is two columns (UniqueName and LineItem). I need to be able to
show that the UniqueName field doesn't appear twice against any
LineItem.

Therefore the formula would need to show any examples where different
LineItems contain the same UniqueName. I've enclosed a set of data
below to 'test' this on.

UniqueName Line Item
IR0000027446-10842 OR11062
IR0000027512-15298 OR15648
IR0000027532-14440 OR16882
IR0000027627-20023 OR16677
IR0000027632-21155 OR19324
IR0000027682-22227 OR21586
IR0000027829-28170 OR28501
IR0000027842-25719 OR23127
IR0000030260-7501 OR4117
IR0000030435-15602 OR13148
IR0000027842-25719 OR132
IR0000030478-16840 OR18805

So in the above data set it would need to highlight that
IR0000027842-25719 appears against OR132 + OR23127

Appreciate your help on this.

Thanks, Al.

Highlighting Data Exceptions
 

Hi,

I think i read you post incorrectly first time so try this conditional
format instead
=(COUNTIF($A$1:$A$12,A1)1)*(COUNTIF($B$1:$B$12,B1 )=1)

Entered in the same way it will highlight duplicates in column A where
Column B is different.

Mike

" wrote:

Hi,

Hope you can help. Had a search around but couldn't quite find the
answer to this problem within the newsgroup.

I have a set of data, spanning just over 60,000 records in Excel.
This is two columns (UniqueName and LineItem). I need to be able to
show that the UniqueName field doesn't appear twice against any
LineItem.

Therefore the formula would need to show any examples where different
LineItems contain the same UniqueName. I've enclosed a set of data
below to 'test' this on.

UniqueName Line Item
IR0000027446-10842 OR11062
IR0000027512-15298 OR15648
IR0000027532-14440 OR16882
IR0000027627-20023 OR16677
IR0000027632-21155 OR19324
IR0000027682-22227 OR21586
IR0000027829-28170 OR28501
IR0000027842-25719 OR23127
IR0000030260-7501 OR4117
IR0000030435-15602 OR13148
IR0000027842-25719 OR132
IR0000030478-16840 OR18805

So in the above data set it would need to highlight that
IR0000027842-25719 appears against OR132 + OR23127

Appreciate your help on this.

Thanks, Al.