Compare columns Excel

Zlatman

Honorable
Oct 7, 2013
4
0
10,510
0
Is there an easy way to compare two columns in Excel? I got two construction job offers. The offers are in Excel. The first column contains activity id and the second the price for the activity. The offers are for the same job, but one of the offers has more activity id’s and therefore contains additional rows. It is not possible just to copy paste because the activity id is not in the same cell (ex. Activity A.1.1 is in cell A11 in the first offer, but in cell A20 in the second offer). It is many rows so I rely don’t want do go through row by row manually.
Now I have to files with the job offers. I want to make a new Excel file (sheet) where I compare each activity. Is there a fast way to do that, or do I have to copy paste each row?
 
Thread starter Similar threads Forum Replies Date
I Laptop Tech Support 1
E Laptop Tech Support 1
M Laptop Tech Support 1
C Laptop Tech Support 6
M Laptop Tech Support 1
D Laptop Tech Support 1
vdicarlo Laptop Tech Support 3
A Laptop Tech Support 4
P Laptop Tech Support 2
T Laptop Tech Support 6
D Laptop Tech Support 2
I Laptop Tech Support 2
J Laptop Tech Support 1
S Laptop Tech Support 3
H Laptop Tech Support 1
V Laptop Tech Support 3
A Laptop Tech Support 2
N Laptop Tech Support 4
mccoolaustinm Laptop Tech Support 2
T Laptop Tech Support 1

ASK THE COMMUNITY