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 ??
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 ??