Find the earliest date&time for a value from different column

[Neyme]

Hi,

I would be very appreciative if 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:

> returns in column 'C' the earliest submission date/time from column 'B' ("Submission Date & Time") for for corresponding value in column 'H' ("Deployed?") but don't return any value (leave the cell blank) if there is no value in column 'H' and if the date/time is not the earliest.

Thus the earliest date/time stamp would be displayed in pivot table below for 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/IF/Index/Match/Min functions but the formula doesn't work: =IFERROR(INDEX(H:H,MATCH(MIN(B:B,0)),"")

The purpose of formula in column 'H' is to narrow down the campaign IDs from column 'K' to the ones that are appended with today's date. I need to verify that today these campaign IDs were deployed.

And the purpose of formula in column 'C' is to get the earliest review submission time, thus validating the time that campaign IDs were deployed and display the time that it was deployed.

DATA_SAMPLE.xlsx

Any help will be very valued!!!

[FDibbins]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.
http://www.excelforum.com/excel-form...onditions.html