Hi Glenn,

Hope you are still doing well. Praying for your Prime Minister...

I need help again. Hoping you might be able to assist.

I now need to calculate the MIN date and the formula you provide (with SUMPRODUCT) doesn't seem to work when trying to find MIN vs MAX.

On the attached:

RawData tab has new Column for A - "Calculated New Value"

This captures any value in the "New Value" column to show "eMotive" if equal to "Jennifer Reed", "App - Premium Offer", or "App - Non Premium Offer".

I now need to capture the FIRST date (or MIN date) of the "Edit Date" field if "Calculated New Value" = "eMotive".

The formula would be entered in the StatTbl tab/Column C (eMotive).

When the formula in StatTbl tab/Column C (eMotive) has:

**=IF(SUMPRODUCT(MAX(--(RawData[Case Number]=[@[UniqueCase'#]])*--(RawData[Calculated New Value]="eMotive")*(RawData[Edit Date])))=0,"",SUMPRODUCT(MAX(--(RawData[Case Number]=[@[UniqueCase'#]])*--(RawData[Calculated New Value]="eMotive")*(RawData[Edit Date]))))**

The eMotive date is populated.

If formula in StatTbl tab/Column C (eMotive) has:

**=IF(SUMPRODUCT(MIN(--(RawData[Case Number]=[@[UniqueCase'#]])*--(RawData[Calculated New Value]="eMotive")*(RawData[Edit Date])))=0,"",SUMPRODUCT(MIN(--(RawData[Case Number]=[@[UniqueCase'#]])*--(RawData[Calculated New Value]="eMotive")*(RawData[Edit Date]))))**

The eMotive date is BLANK

I have done some reading and read that the MIN and SUMPRODUCT don't always play nice. Everything I have tried does not work. Any ideas?

Thanks (again...) for your help.

Take care.

see attached