Hi,
I have an array formula using INDEX/MATCH to provide me the value when there are two criterias. (This formula is needed for column D on the 'StatTbl' tab)
In the attached, I have finding the value of the 'Edit Date' when:
New Value (column G) = Tech Review
AND
Case Number (column A) on the Raw Data tab = UniqueCase# on the StatTbl tab
The formula to provide the above is:
{=INDEX(RawData[Edit Date],MATCH(1,("Tech Review"=RawData[New Value])*([@[UniqueCase'#]]=RawData[Case Number]),0))}
What I want to find is, the MAX date when the formula looks for the "Tech Review"=RawData[New Value].
There are 2 situations that the New Value on the RawData tab has 2 dates for the same Case Number. (40738 & 53022).
Right now the formula is generating the first date for those case numbers. I need the 'MAX' date.
I cannot figure out the syntax to find this value.
All help would be beneficial.
Thanks
Bookmarks