I am putting together a spreadsheet on Excel 2007 with data that I am exporting from a program called Flowlink.
Flowlink is a program for monitoring water flow, head height, pH, etc. in municipal water systems.
I have date/time in column A, flow rate in column B, and head height in column C.
The data is listed in 10 minute intervals for a full month, on my spreadsheet, the date parameters are from 5/1/2012 0:00
to 5/31/2012 23:50.
I have a line for minimum flow using =MIN(C17:C4480) , maximum flow using =MAX(C17:C4480) , and average flow using =AVERAGE(C17:C4480).
What I want is, next to the cell that shows the minimum flow, I want to have the date/time of the minimum flow event automatically pasted into the next cell. In other words, I have the spreadsheet programmed to tell me what the minimum flow was, but I need it to tell me when the event occured.
Can somebody help me please?
Thanks.
Bookmarks