Hi
not really sure. Best would be if you could post some example rows of
data (plain text please) and explain your expected result
--
Regards
Frank Kabel
Frankfurt, Germany
Minitman wrote:
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
|