Find Unique Changes
 

I have a very large spreadsheet with only 2 columns, looks like this below:
The first column is the part #
The second column is the manufact.
I want to make a third column to identify every part# that has more than one
manufacturer, in this case it would be Part #D317001 because it has Jet004 &
Let001 as vendors for the same part. Sounds easy but i cannot get this to
work.
I setup a pivot table but the list is 40,000 lines long.
, please help if you can.

#DNV DNV001
#DNV DNV001
#D317001 JET004
#D317001 LET001
#D317001 LET001
#D317001 JET004
EB184 TIM006
EB184 TIM006
EB185 TIM006

Find Unique Changes
 

Data in b5:c18 and formula in column d...
=IF(SUMPRODUCT(--($B$5:$B$18=B5),--($C$5:$C$18<C5))0,B5,"")
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Francis"
wrote in message
I have a very large spreadsheet with only 2 columns, looks like this below:
The first column is the part #
The second column is the manufact.
I want to make a third column to identify every part# that has more than one
manufacturer, in this case it would be Part #D317001 because it has Jet004 &
Let001 as vendors for the same part. Sounds easy but i cannot get this to
work.
I setup a pivot table but the list is 40,000 lines long.
, please help if you can.

#DNV DNV001
#DNV DNV001
#D317001 JET004
#D317001 LET001
#D317001 LET001
#D317001 JET004
EB184 TIM006
EB184 TIM006
EB185 TIM006

Find Unique Changes
 

Works great. Thank you.

"Jim Cone" wrote:


Data in b5:c18 and formula in column d...
=IF(SUMPRODUCT(--($B$5:$B$18=B5),--($C$5:$C$18<C5))0,B5,"")
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Francis"
wrote in message
I have a very large spreadsheet with only 2 columns, looks like this below:
The first column is the part #
The second column is the manufact.
I want to make a third column to identify every part# that has more than one
manufacturer, in this case it would be Part #D317001 because it has Jet004 &
Let001 as vendors for the same part. Sounds easy but i cannot get this to
work.
I setup a pivot table but the list is 40,000 lines long.
, please help if you can.

#DNV DNV001
#DNV DNV001
#D317001 JET004
#D317001 LET001
#D317001 LET001
#D317001 JET004
EB184 TIM006
EB184 TIM006
EB185 TIM006