Hi,
I'm a geology student and I've been set an assignment based around data from the National River Flow Archive (http://www.ceh.ac.uk/data/nrfa/index.html). The data for each station gives the average river flow for each day since records began (for the five different rivers I'm looking at this is between 1957 and 1976) up to the end of 2010. It is presented in the form of two columns, the left gives the date and the right gives the flow. What I need is the minimum flow value for each year, for all five rivers. I could do this manually, but as I'm sure you can imagine there is a lot of data here and I was hoping there might be a more efficient way of going about it. If I could use the sort function to sort by year then by flow that'd be fine, but it seems I can only sort by date. Any suggestions would be hugely appreciated and would save me hours of tedium!
Bookmarks