| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Earliest date & time
The dates and times are still in A1/B1 and in C1/D1 and the serial number is in E1.
Which date and time does the serial number represent? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Earliest date & time
=IF(E1=A1+B1,ADDRESS(ROW(),1,4)&":"&ADDRESS(ROW(), 2,4),IF(E1=C1+D1,ADDRESS(ROW(),3,4)&":"&ADDRESS(RO W(),4,4),""))
isabelle Le 2016-10-26 Ã* 19:54, GARYWC a écrit : The dates and times are still in A1/B1 and in C1/D1 and the serial number is in E1. Which date and time does the serial number represent? |
|
#3
|
|||
|
|||
|
Lắp đặt, dÃ*n dá»±ng sân khấu chuyên nghiệp -LH 0911 000 222 Äạt PhÆ°Æ¡ng - ÄÆ¡n vị chuyên cung cấp, cho thuê âm thanh - ánh sáng - cung cấp, lắp đặt sân khấu phục vụ sá»± kiện chuyên nghiệp. ... Chuyên thiết kế, cung cấp vÃ* lắp đặt hệ thống thiết bị âm thanh, ánh sáng, không gian, ...sân khấu. Liên hệ Mr Äạt 0907 150 220 [center]   
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Earliest date and time | Excel Programming | |||
| Earliest time in a range | Excel Worksheet Functions | |||
| Earliest Date to populate? | Excel Worksheet Functions | |||
Linear Mode
