Hi,
I am needing to find the 'MAX' date in the 'Edit Date' column when the 'New Value' column is equal to 'Tech Review'.
There are two case numbers that have two different dates for that scenario and I need to capture the latest or 'MAX' date vs the first date.
on my StatTbl tab I have the formula in column D:
{=INDEX(RawData[Edit Date],MATCH(1,("Tech Review"=RawData[New Value])*([@[UniqueCase'#]]=RawData[Case Number]),0))}
I cannot figure out how to grab the MAX of the value I am trying to populate in that cell.
Any help would be appreciated.
see attached