Thread: Need reference for max and [#this row] functions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default 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 With QuoteReply With Quote