njbeancounter
Board Regular
- Joined
- Oct 7, 2002
- Messages
- 158
My spreadsheet has 20 rows and 20 columns containing accounts receivable information. I then have the same grid for accounts payable information. Below is a simplified version. I want to, as easy as possible, list the differences from what each company shows as a/r compared to what the offsetting company shows as a/p. For instance, company A has a receivable in the amount of $10 from company B. However, company B shows a payable to company A in the amount of $9. How can I list this all out without manually typing in each possible scenario?
Thanks in advance...
A/R
a b c d e f g h i j k l m n o p q r s t
a 10 20
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum
A/P
a b c d e f g h i j k l m n o p q r s t
a
b 9
c 15
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum
Thanks in advance...
A/R
a b c d e f g h i j k l m n o p q r s t
a 10 20
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum
A/P
a b c d e f g h i j k l m n o p q r s t
a
b 9
c 15
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum sum