Geek Answers Handbook

How to compare two columns in Excel?

Our organization has offices in several Zip codes in all 50 states. Each year, some new offices open, some current offices are closed. Almost forgot: we have our own designations for offices.

Year   Office Code   Zip Code        Status
2009   Z10           20701           Open
2009   Z11           20703           Open
2009   Z12           20701           Open

2010   Z10           20702           Open
2010   Z11           moved to 20702  Open
2010   Z12           NA              Closed
2010   Z14           20707           Open - Added (didn't exist last year)

In 2009, I have a list of postal codes of our existing offices. This list of postal codes is different in 2010.

Is there an easy way to compare zip codes lists and a report on which respective offices were closed / opened / moved?

+5
source share
1 answer

Say you want to find them in col. B without coincidence in col. A. Put C2:

=COUNTIF($A$2:$A$26;B2)

This will give you 1 (or more) if there is a match, 0 otherwise.

, , Goto Special, Row Differences. , , .

+6

More articles:


All Articles