H
henriques
Need a formula for the no matching items in a worksheet with the following
data:
Columns A, B and C are the data for 2008
Column A- Customer number
Column B – Account number
Column C – Balance in €
Columns D, E and F data for 2007
Note that it is possible to have customers in 2008 without balance in 2007
and customers in 2007 that don´t have balance in 2008
One customer can have more than one account and different accounts for 2007
and 2008.
What I need is to retrieve in columns G, H and I customers of 2008 that do
not match 2007 for customer and/or account.
Ex.
A B C D E F G H I
110032 228 100 110052 268 85 110032 228 100
110032 268 76 110059 228 87 110032 268 76
110052 268 70 110142 221 88 110052 221 74
110052 221 74 110302 228 77 110102 221 79
110102 221 79 110142 228 81
110142 228 81
110302 228 65
Thanks in advance for your support
data:
Columns A, B and C are the data for 2008
Column A- Customer number
Column B – Account number
Column C – Balance in €
Columns D, E and F data for 2007
Note that it is possible to have customers in 2008 without balance in 2007
and customers in 2007 that don´t have balance in 2008
One customer can have more than one account and different accounts for 2007
and 2008.
What I need is to retrieve in columns G, H and I customers of 2008 that do
not match 2007 for customer and/or account.
Ex.
A B C D E F G H I
110032 228 100 110052 268 85 110032 228 100
110032 268 76 110059 228 87 110032 268 76
110052 268 70 110142 221 88 110052 221 74
110052 221 74 110302 228 77 110102 221 79
110102 221 79 110142 228 81
110142 228 81
110302 228 65
Thanks in advance for your support