M
Minitman
Greetings,
I have to see if one three conditions exists:
1) Missing BS items for existing DT items - <Pink>
2) Missing DT items from existing BS items - <Light Blue>
3) Both have some missing - <Light Purple>
The first Conditional Format will be in A1, B1, C1 and D1. These are
the 4 columns that have information:
A) Date (BS & DT)
B) Account (BS & DT)
C) BS Amount
D) DT Amount
I need to turn the contents of A and B into some kind of transaction
ID. The date need only be in dd format. The Account has either
xxxxxxxx or xxxxxxxxx-x format, they are both present.
BS entries have Date, Account and Amount
DT entries also have Date, Account and Amount, only different amounts.
DT Amounts for the same Date-Account added together will be equal to
BS Amounts for the same Date-Account added together. This is the
default condition.
I think SUMIF is involved, but I am not sure how.
Anyone have any ideas?
Any help would be appreciated.
TIA
-Minitman
I have to see if one three conditions exists:
1) Missing BS items for existing DT items - <Pink>
2) Missing DT items from existing BS items - <Light Blue>
3) Both have some missing - <Light Purple>
The first Conditional Format will be in A1, B1, C1 and D1. These are
the 4 columns that have information:
A) Date (BS & DT)
B) Account (BS & DT)
C) BS Amount
D) DT Amount
I need to turn the contents of A and B into some kind of transaction
ID. The date need only be in dd format. The Account has either
xxxxxxxx or xxxxxxxxx-x format, they are both present.
BS entries have Date, Account and Amount
DT entries also have Date, Account and Amount, only different amounts.
DT Amounts for the same Date-Account added together will be equal to
BS Amounts for the same Date-Account added together. This is the
default condition.
I think SUMIF is involved, but I am not sure how.
Anyone have any ideas?
Any help would be appreciated.
TIA
-Minitman