I have a Table with over 7000 rows of flow data (daily totals), and four columns.
Columns are:
Date
Flow from River
Flow to River
Bio In
I have used maxif to find the max value for a given date range (either quarterly or yearly), but I would like to return the date that the max value occurred.
I need a formula for the date for "Flow to River" max in a given date range please.
Does anyone have a formula to acheive this please?
All data is in date order.
Columns are:
Date
Flow from River
Flow to River
Bio In
I have used maxif to find the max value for a given date range (either quarterly or yearly), but I would like to return the date that the max value occurred.
I need a formula for the date for "Flow to River" max in a given date range please.
Does anyone have a formula to acheive this please?
All data is in date order.