Comparing two columns of information with 2 new columns of informa
 

Column A contains the fund number. Column B contains the account number.
These columns are used to form a unique fund/account code. Column C contains
the balance for each unique fund/account code. The same fund code will be
used for multiple account codes; the account code could be used with multiple
fund codes.

I have downloaded updated information in columns D-F. I want to compare the
new information (column D & E) with the old information (column A & B) and
somehow identify information that has been added (new in D & E) since the
last time (A & B).

I know how to do this when comparing one column of information with another
single column. It's the two-column criteria that is confusing me.

Any thoughts?

Comparing two columns of information with 2 new columns of informa
 

Jut throwing it out there...

Would it be ok to concatenate?

make a column that will be
=A2&B2
to combine the columns?

then:
=D2&E2
to combine the new

Then, you are comparing one column with one column...

"cbuck" wrote:

Column A contains the fund number. Column B contains the account number.
These columns are used to form a unique fund/account code. Column C contains
the balance for each unique fund/account code. The same fund code will be
used for multiple account codes; the account code could be used with multiple
fund codes.

I have downloaded updated information in columns D-F. I want to compare the
new information (column D & E) with the old information (column A & B) and
somehow identify information that has been added (new in D & E) since the
last time (A & B).

I know how to do this when comparing one column of information with another
single column. It's the two-column criteria that is confusing me.

Any thoughts?