Hello Board,
Here is my dilemma.
I am trying to populate column H with the MAX date from column C where:
item code matches (A=G)
D is blank
If no items in D are blank, make zero. (I will conditional format so it's blank and not 1/0/1900 if I need to)
Note, this table A-D will NOT be...