Hi,
I'm trying to calculate the difference between 2 ranges (each range is a different tab). I have a table that generates values and I want my function to be able to change the row value based on the return value in the table.
For example, on cell A1, I have the formula '=AVERAGE(Data1!A2:C2)-AVERAGE(Data2!A2:C2)'
If one of the table values, cell "G10' returns the value '5', I want my formula to pick up the value and change the formula to
'=AVERAGE(Data1!A5:C5)-AVERAGE(Data2!A5:C5)'
Is this possible to achieve? thank you so much in advance and sorry for the poor English.
Bookmarks