I believe this is a relatively easy formula. I just can not seem to write the formula. I have dates for 365 days. Each day has 24 hours with each hour showing a census. I need to know what the max census is per day for the 365 days.
Example of data:
Columns : Date; Hour; Census
Rows how data is displayed: 1JUNE2017; 1JUNE17…1JUNE2017 (all the way to 1JUNE2018)
00:00; 01:00: 02:00…24:00
21; 20; 17…21