| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need reference for max and [#this row] functions
I use the formula =MAX(Table1[[#This Row],[12:30 PM]]-1,0) but can't remeber
the web page where I found it. I believe it was on the Microsoft site. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need reference for max and [#this row] functions
You need to post only once to the list, not three times. Also you need to be
clear what your question is. Press F1 and type in "Using structured references with Excel tables" -- If this helps, please click the Yes button. Cheers, Shane Devenshire "SCC" wrote: I use the formula =MAX(Table1[[#This Row],[12:30 PM]]-1,0) but can't remeber the web page where I found it. I believe it was on the Microsoft site. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Need to reference existing functions in a custom function: possibl | Excel Worksheet Functions | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Linear Mode
