Compare Bill of materials

  • Thread starter Thread starter Tom Travis
  • Start date Start date
T

Tom Travis

I am working with several "Bill of materials" and many have several items
the same. My task is to determine the items that are not the same and list
or hil-ight them for more detailed work. The comparison will be on a line
for line basis - not a full "Range" comparison.

Is there a way in Excel to compare more than two lists?

Thnaks

Tom Travis
 
I use Access to do basically the same type of comparison.
With Access you can link the spreadsheets into different
tables within a database and then use a prebuilt Query
wizard that will tell you what those differences are. I'm
not sure if you could then highlight those and have it
show on your spreadsheet, I haven't tried that yet. If
you find out an answer withni Excel I'd be interested
also.

Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
Summing multi-level bill of material 6
Bill of materials 9
Compare 2 worksheets 1
bill of materials query 1
how do I compare 2 spreadsheets of data? 1
Is there a Formula to do the advance Filter Unqiue records,but not having blank lines 3
Bill Of Materials 1

Back
Top