Hi

I work for a transport company and receive a report daily that shows
multi-part consignments by postcode and which van the items are loaded
on. Most of the parcels for a consignment will be on the same van but
ocassionally, one of them might be on a different vehicle.

For example, take these three columns -

ZIP CODE VAN DELIVERY DEPOT
HG5 9LZ 201 York Depot
HG5 9LZ 201 York Depot
HU7 3JD 124 York Depot
HU7 3JD 124 York Depot
HU7 3JD 124 York Depot
HU7 3JD 124 York Depot
HU7 3JD 124 York Depot
M30 7PJ 116 Manchester Depot
M30 7PJ 201 Manchester Depot
M30 7PJ 116 Manchester Depot
M30 7PJ 116 Manchester Depot
M30 7PJ 116 Manchester Depot
LS28 5PX 226 Leeds Depot
LS28 5PX 226 Leeds Depot
LS28 5PX 226 Leeds Depot

The postcode / zip code for each part of the consignment match the
vehicle number. As you can see from the above example, one parcel
going to M30 116 is on a different van.

Is there a quick way to highlight a batch of parcels where the van
number does not match the van number of other parcels going to the same
zip code? This report contains several thousand rows and I need to
check it visually every morning.

Any help would be appreciated,

Scott


--
Scotty_MK
------------------------------------------------------------------------
Scotty_MK's Profile: http://www.excelforum.com/member.php...o&userid=21873
View this thread: http://www.excelforum.com/showthread...hreadid=570055