Home » Forums » Open Source Learning Center » Question and Answer

calculations across sheets in excel 2010

Submitted by shepherd711 on 24 March, 2014 - 18:24

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
‹ Autorun macro VBA and combo box filtering ›
»
Vikas Verma's picture

Please share

Submitted by Vikas Verma on 25 March, 2014 - 01:06.

Hi Dear,

Please share your workbook...

thanks

»

calculations across sheets in excel 2010

Submitted by shepherd711 on 25 March, 2014 - 13:16.

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?"

»