Comparing two columns of data
 

I hope that the anwer to this question isn't as obvious as it possibly is.

I have information from two databases merged into one Excel document. All
fields are matched side by side, as pretaining to what their data is about
(approximately 12 columns of info). I have them sorted by part location then
part numbers. Ultimately, I want to know what locations still match between
the two databases as pretaining to my inventory, then for what locations are
different, where the parts are currently located. I think that I have
achieved this, but I want to have a quick way of looking at all 4000+ parts
in the inventory list to determine where the descrepantcies are. Is there a
way for every cell in the part location columns that do not match to be
highlighted or sorted? Then for every part number that do not match to be
highlighted or sorted also? Here is an example of what I have in Excel.

Whe C= Current
O=Old

CPart# Opart# CPartName OPartName CLocation OLocation
123 123 Washer Washer ABC
ABC
456 789 Bolt Bolt DEF
DEF
1A1 1A1 Pin Pin GHI
JKT

AS you can see in the above example I only have one where the Current Part#
matches the Old part#, AND the Current Location, matches the Old Location.
This is good, but I want to be able to ascertain the information where in the
above example I have two more that either have part number differences or
location differences. (the way I have it sorted, I cannot have both at the
same time.)

I hope I haven't been too confusing. Any or suggestions is appreciated.

Comparing two columns of data
 

Use a pivot table. More info he http://www.cpearson.com/excel/pivots.htm

Dave
--
Brevity is the soul of wit.


"JOHNV" wrote:

I hope that the anwer to this question isn't as obvious as it possibly is.

I have information from two databases merged into one Excel document. All
fields are matched side by side, as pretaining to what their data is about
(approximately 12 columns of info). I have them sorted by part location then
part numbers. Ultimately, I want to know what locations still match between
the two databases as pretaining to my inventory, then for what locations are
different, where the parts are currently located. I think that I have
achieved this, but I want to have a quick way of looking at all 4000+ parts
in the inventory list to determine where the descrepantcies are. Is there a
way for every cell in the part location columns that do not match to be
highlighted or sorted? Then for every part number that do not match to be
highlighted or sorted also? Here is an example of what I have in Excel.

Whe C= Current
O=Old

CPart# Opart# CPartName OPartName CLocation OLocation
123 123 Washer Washer ABC
ABC
456 789 Bolt Bolt DEF
DEF
1A1 1A1 Pin Pin GHI
JKT

AS you can see in the above example I only have one where the Current Part#
matches the Old part#, AND the Current Location, matches the Old Location.
This is good, but I want to be able to ascertain the information where in the
above example I have two more that either have part number differences or
location differences. (the way I have it sorted, I cannot have both at the
same time.)

I hope I haven't been too confusing. Any or suggestions is appreciated.