Hi,
Can one of the forum experts please help me to come up with the formula which returns earliest date/time for the email campaign IDs in "Deployed?" column in the attached spreadsheet?
The ultimate goal is for pivot table (Pivot tab in the file) to display date/time stamp when first review was submitted for the corresponding campaign ID. I inserted a column 'C' ("Date & Time for Deployed?") in "Data" tab where I want to insert the formula which:
> searches column 'B' ("Submission Date & Time") for earliest submission date/time for corresponding value (campaign IDs) in column 'H' ("Deployed?") and returns only earliest date/time but don't return any value if the date/time is not the earliest.
Thus the earliest date/time stamp would be displayed in pivot table below the each campaign ID for 5 Day email and for 28 Day email when "Date & Time for Deployed?" field is added to 'Row Labels' in the pivot table.
For example, '5day_latency_RZ040815' campaign ID from "Deployed?" column has total of two date/time stamps in column B ("Submission Date & Time"): 4/8/15 8:55:43 AM and 4/8/15 8:25:04 AM. Note, that the actual data is larger than the sample I provided and for one campaign ID can be hundredth date/time stamps.
The earliest date that I need to be displayed in the pivot table is 4/8/15 8:25:04 AM, it is when the first review submissions was made, meaning that 5 Day email was deployed.
I am trying to use IFERROR/Index/Match/Min functions but the formula doesn't work: =IFERROR(INDEX(H:H,MATCH(MIN(B:B,0)),"")
Any help will be highly appreciated!!!
DATA_SAMPLE.xlsx
Bookmarks