|
|
|
|
#1
02-09-2020, 07:21 AM
|
||||
|
||||
In E2, either:
=MINIFS($C$2:$C$14,$B$2:$B$14,B2) which will put the earliest time against all rows, or: =IF(MINIFS($C$2:$C$14,$B$2:$B$14,B2)=C2,C2,"") which will only show a time on rows where the time is the minimum for that day. 
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| OneNote on Android phone View Tags? Enter Date, Time, Date & Time | DrTwinkyEsq | OneNote | 0 | 03-27-2017 07:54 PM |
| Microsoft Project 2016 print specific date range stuck on one date | martinsalmon | Project | 1 | 10-12-2016 11:36 AM |
 date & time of last time a recent file was used
|
pgeorgilas | Word | 1 | 10-31-2014 08:59 AM |
| Greater than today at a specific time | cangelis | Excel | 6 | 10-01-2014 08:48 AM |
| Count the common time period (month) between two date period of time | Barni | Excel | 6 | 08-15-2014 07:52 AM |
Windows 10 
Office 2019
Hybrid Mode