How do I compare two columns in excel? - TechRepublic
Question
October 13, 2008 at 12:35 PM
pam.barclay

How do I compare two columns in excel?

by pam.barclay . Updated 17 years, 9 months ago

I am trying to compare two columns of data in excel. The first column represents image files(referenced as model number) and the second column represents the model number. I would like the cells to line up next to each other. The problem is I do not have all of the images so that column is shorter than the data column. Here is an example of the subset of data I am working with. Can you provide any advice? Thanks!

001-AB 001-AB
002-TS 001-TS
003-AB 002-AB
003-TS 002-TS
005-TS 003-AB
007-AB 003-TS

This discussion is locked

All Comments