Compare 4 columns & find dissimilar

Joined
Jul 2, 2011
Messages
6
Reaction score
0
I have 2 spreadsheets with 2 columns in each that I need to compare. Sheet A has a part and a price column, as does Sheet B. I need to compare the part column in A to B and then the price column in A to B and if the price of the part in A is different than the price of the part in B, I need to calculate the difference in a separate column. Can anyone help?
 
Joined
Jun 9, 2016
Messages
32
Reaction score
5
Upload spreadsheets A & B and I'll do it. I'd rather not have to spend more time setting up the problem than it'll take me to solve it. I've spent most of my day creating sample data and using it to solve problems that have been posed. I could have helped several more people if everyone had uploaded sample files with sample data. Not only that, but it makes the problem a lot easier to understand.
Thanks!
 

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

Top