Every first time of the day

In cell C2:

=MIN(B1:B100)

Sorry I didn't see the dates are different. You will need an index match array for that. I will get to it.

Try this:

Sheet3




Excel tables to the web >> Excel Jeanie HTML 4

BillyRaySpivy said:

Try this:

Sheet3

	A	B	C	D	E
2	1/1/2017	1:05:00 AM		1/1/2017	1:05:00 AM
3	1/1/2017	12:05:00 PM		2/1/2017	1:32:00 AM
4	1/1/2017	1:15:00 AM		1/1/2017	1:05:00 AM
5	1/1/2017	2:00:00 AM
6	2/1/2017	1:32:00 AM
7	2/1/2017	2:45:00 AM
8

<tbody>
</tbody>

Spreadsheet Formulas

Cell Formula E2 {=IFERROR(IF(COUNTIF($A$2:$A$10,$D2),MIN(IF($A$2:$A$10=$D2,$B$2:$B$10)),""),"")} <tbody> </tbody>

Formula Array: Produce enclosing { } by entering formula with CTRL+SHIFT+ENTER!

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Click to expand...

First of all: Sorry for the delay...

Many thanks for the above.
I am not an Excel expert, regretfully so.

Gave the formula a try, but I think there may an error somewhere.
Or, I might be doing something wrong, which is most likely...

Hope you can figure out what I am doing wrong.

Thanks again!

That looks correct but did you drag it down after making it an array?

I am sorry, I don't know exactly what you mean.

I tried following possibilities
a. clipboard copy from { uptil } ({} included) - then switched to Excel - cel E2 - ctrl-shift-enter : nothing shows up
b. clipboard copy from { uptil } ({} included) - then switched to Excel - cel E2 - paste - ctrl-c E2 - selected region E3-E25 - ctrl-shift-enter: nothing happens
c. select pasted formula in E2, dragged down - formula is copied only

probably ctrl-shift-enter does not work.
and a workaround should be found for that.

I noticed various threads on this non-working ctrl-shift-enter
Sofar I have not found a solution.

I give up.

Thanks anyway!

=

Don't give up .. array formulas are confusing at first but its worth persisting

2 problems - first thing Do NOT enter the curly brackets . when you do CRTL-SHIFT-ENTER excel will put the curly brackets in for you . if you copying-and-pasting from this site just delete the curly brackets
2nd - your data runs from rows 2 to 17 but the formula in post 3 only looks at rows 2 to 10

Point is: nothing gets pasted at all...

So:
I copy the above, from '=' upto the last ')'
paste it into a -new- sheet will show the formula in the cell (this is just to show that it -is- pasted)

Okay, now the same but then in the sheet with dates/times, select cell e2 and do a ctrl-shift-enter, the cell remains empty and nothing happens.
I might also select the formula from the other sheet and ctrl-shift-enter into E2 with date/time sheet, same thing, E2 remains empty, nothing happens.

One way or the other I get the impression that for one reason or the other ctrl-shift-enter is disabled or so.
(noticed there are many, many questions on Internet regarding the non-working ctrl-shift-enter in Excel)

No idea why it doesn't work.
I disabled my clipboard manager
I had excel started without personal.xlsb

Nothing, bad luck.

=

I Think you can use this formula.. It going to work

=IFERROR(IF(COUNTIF($A$2:$A$17,$D2),MIN(IF($A$2:$A$17=$D2,$B$2:$B$17)),""),"")

Thanks,
Dinesh Babu.