Question Locked

How do I compare two columns in excel?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

This discussion is closed to new replies.