Min Function with multiple criteria

[Henry c]

Hi

I basically need a formular that returns a value for the earliest time on a Monday morning for a certaan person in a sheet of data.

My data has 4 columns

A = Employee Number

B = Times

C = Days

D = Event



So basically at the ealiest time that data is present on a Monday, for a certain person, i would like the formular to show the event that occured at that time from column D.

I have been trying to add multiple criteria to the =MIN function, but am only managing to return the earliest time on a Monday and not the coressponding event.

Note employee number is 3 digits, time is in format 00:00:00, days are in format DDDD and the event is a 6 figure number.

Does anyone know the best way to go about this?

Kind Regards

[JeanRage]

Hi,

With array formula ... : Min(If( ...

Why don't you post a sample worksheet for a precise answer ...

HTH

[Henry c]

As suggested here is an example with simplified data removing personal details.

Thanks

[JeanRage]

Among many possibilities, see attached proposal ...

HTH

[Henry c]

Thanks Very Much, greatly appreciated.

Henry

[Palmetto]

Please note that the time values in your original sample workbook are NOT real time values - they are text. As such, Jean Rage's solution will not work unless you convert the text values into real numbers. He has done the conversion in the workbook he provided.

You can use the PasteSpecial (Multiply x 1 or Add + 0) to convert the text into real times, then format then as time so that they display correctly.