extracting unique dependent on three lists

C

crew3407

Hello,

I was wondering how to extract changes that have been made from
previous set of data to a new set of data.

Col A Col B Col C Col D
Acct # Name Acct # Name
1 hello 0 wow
2 yes 2 yes
1 hello

So my question is, I want to first check to see if the Account # in
exists in C. If it does exist, then I want to check if th
corresponding info next to the account #'s are the same. If they ar
not the same, then pull out the account #. The second list is mos
likely always going to be longer because new accounts are added.

I know Pearson has a good site with comparing 2 lists, and I've use
the IF(COUNTIF(......), " ", " ") function to extract uniques from
list, but above i want to check 2 conditions. Is this possible?
Thanks
 
C

crew3407

the last line in my example list, the "1" and "hello" should be unde
col C and D respectively. Sorry about that
 
F

Frank Kabel

Hi
one workaround: combine both columns in a helper column with
=A1&B1
and use these procedures on the helper column
 
C

crew3407

Hi Frank,

Thanks for the reply...however i'm not sure that does the trick, unles
i'm misunderstanding. If i were to combine A and B and then combine
and D and then extract the uniques from the 2 new combined lists, the
different account numbers will also be extracted as unique.

I need for the old account number and the new account numbers to matc
first as my first condition. Then if the information corresponding t
those account numbers don't match, i want to extract that. is thi
possible?

Thank
 
P

Peo Sjoblom

=IF(AND(old=new,info1<>info2),"info2","")

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
C

crew3407

For your formula that you wrote down, do the lists have to be of sam
length? My lists are different lengths, but ordered alphabetically
with the new list having more accounts. Sorry if I'm not getting it.
Thanks for the reply
 
Top