| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Running two formulas as one
Hello from Steved
This will save an extra lookup column G:G "converts Col C:C 0830 to 8:30:00 a.m." {=INDEX('Duties Mon-Fri '!$F$2:$F$60000,MATCH(TEXT(B2,"0000")&CHAR(1)&C2,' Duties Mon-Fri '!$B$2:$B$60000&CHAR(1)&'Duties Mon-Fri '!$G$2:$G$60000,))} TEXT('Duties Mon-Fri '!C2,"00\:00")*1 Thankyou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas--running balance | Excel Worksheet Functions | |||
| Running all data through a set of formulas | Excel Discussion (Misc queries) | |||
| running totals, named formulas | Excel Worksheet Functions | |||
| pivot table formulas - running total | Excel Discussion (Misc queries) | |||
| How can I save the formulas when running a macro? Need ASAP!! | Excel Discussion (Misc queries) | |||
Linear Mode
