I will remember that I was un aware the first site would ask for all that. I have tried using the format and formula you provided; However, on my spreadsheet it results in no values. Probably user error lol. Regarding the changes, is there any way of populating the correct data from the original...
http://www.filedropper.com/exampledata
Here is the data sheet I using, with the formula I am using I am coming up with incorrect numbers for FY 13 data.
I am trying to populate chart data for a specific Fiscal Year and Month based on a specific data table. Fiscal year is on one row followed by the month underneath while the data
FY12 FY12 FY13 ""
JAN FEB MAR ""
Data 1
Data 2
Data 3
""
I am wating to be able to...