Hi guys,
Difficult one..
I need to copy a formula to the right in a spreadsheet ,but the input data to the formula is located in another spreadsheet in every third column, so i cant just copy the formula to the right in my ouput sheet.
Is there a way of getting around this problem within the formula?
Thnx allot!!
Difficult one..
I need to copy a formula to the right in a spreadsheet ,but the input data to the formula is located in another spreadsheet in every third column, so i cant just copy the formula to the right in my ouput sheet.
Is there a way of getting around this problem within the formula?
Thnx allot!!