Find Date and Time for a value

[hanif]

Hi All,

I have a set of data. Col A is a range of dates and row 1 is range of time. I need to look up in these data and find the Min value and the date and the time that Min value occured. Can anyone help please?

I have attached the spreadsheet for example of what I am looking and better understanding. My Data is on Data sheet and my expectation is on Analysis sheet.

Thanks.

[tim201110]

offset, match and countif

[hanif]

Thanks Tim

[JohnTopley]

In D9

=INDEX(Data!A1:A366,SUMPRODUCT((Data!$A$1:$AW$366=Analysis!$D$8)*(ROW(Data!$A$1:$A$366))))

in D10

=INDEX(Data!A1:AW1,,SUMPRODUCT((Data!$A$1:$AW$366=Analysis!$D$8)*(COLUMN(Data!$A$1:$AW$366))))