Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

monthly reports & hourly max by day

Status
Not open for further replies.

bobmorane

Technical User
Jul 2, 2002
38
0
0
FR
Hello !
I have to deal with a monthly report displaying all 31 days in a tab shape
My problem is, that a specific field needs to be an hourly maximum of a day, for all days.
At first i thought about making one tab for one day, with 24 cells (one by hour), then taking the 31 max of the 31 tabs to display... after a little operation, i found out I'd have to create 744 formulas !!

>>> Is there a way to make things easier and(or) faster ??
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top