calculations across sheets in excel 2010

I have created a excel spreadsheet for 25 years of weather data. There is one sheet for each year; each sheet labeled with the year and with the year also listed in A1. Months are in columns and records are nested withing months. All years (sheets) are formatted the same. I am able to summarize data using an expression like MIN('1989:2014'!G48) which returns a correct value, but I also want to know in which year (sheet) the value exists. Is there an expression that will retrieve this additional info?

AttachmentSize
Weather Records.xlsx651.75 KB
Vikas Verma's picture

Please share

Hi Dear,

Please share your workbook...

thanks

calculations across sheets in excel 2010

I have amended the original posting to include the workbook.
Note: I can retrieve an answer to the query: "What was the warmest July since 1988?" but would also like to be able to retrieve the answer to "In what year did this occur?"