Hi,
I'm trying to calculate the difference between 2 ranges (each range is in 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 C5, I have the formula '=AVERAGE(Data1!A2:C2)-AVERAGE(Data2!A2:C2)'
If one of the table values, cell H5 returns the value '5', I want my functionion 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.
I'm trying to calculate the difference between 2 ranges (each range is in 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 C5, I have the formula '=AVERAGE(Data1!A2:C2)-AVERAGE(Data2!A2:C2)'
If one of the table values, cell H5 returns the value '5', I want my functionion 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.