View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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