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.

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.