Apr 24 2019 10:33 AM
I have a simple formula: =D13801/Calibration!$G$48
The first part is a cell reference on my current page. What I need is for that digit at the end, 48 in this example, to be the contents of a different cell, so I don't have to type that number into each line as needed. I'm using the same digit for three hundred consecutive lines, then it ticks up by 1, then another three hundred lines, etc.
I already have a column set up with the correct sequence of digits I want to appear at the end of the formula in each row, I just don't know how to use the contents of those cells in the formula. Typing them in by hand on each line is far too time consuming, as they are many.
I thought I might be on the right track with the INDIRECT function, but couldn't get it to work. Maybe my syntax is wrong, or maybe it doesn't actually work the way I think it does.
Thank you.
Apr 24 2019 11:37 AM
Apr 24 2019 11:54 AM
Thank you for responding.
I typed a sample formula into the original comment. I just have that one to work with. I will attach the file I'm working with, but there's a lot of other stuff in it. If you look at the tab called <Data 300 Counts> and look down column G, you can see what I'm trying to do. I've done a number of entries by brute force, but it would take me a long time to get through them all doing a copy/paste with a typed edit once each 300 rows.
I want the first cell (in the formula in column G on <Data 300 Counts>) to increment by one as I copy the formula down the column, but I only want the digit on the end to increment by 1 once each 300 rows.
Thank you for the help.
Apr 24 2019 11:59 AM
I already have the digits I want on the end of the formula, in the cells in column H, but I don't know how to concatenate those onto the end of the formulas in column G and have it accept it as part of the formula string.
Apr 24 2019 11:15 PM - edited Apr 24 2019 11:18 PM
SolutionInstead of D1/Calibration!$G$2, use this formula in G1, copied down rows:
=D1/INDEX(Calibration!G:G,
CEILING(ROW(),300)/300+1)
The divisor in the foregoing formula becomes Calibration!G2 for G1:G300, Calibration!G3 for G301:G600, Calibration!G4 for G601:G900, and so forth.
Apr 25 2019 07:29 AM
Apr 25 2019 11:49 AM
Apr 25 2019 12:14 PM
Apr 24 2019 11:15 PM - edited Apr 24 2019 11:18 PM
SolutionInstead of D1/Calibration!$G$2, use this formula in G1, copied down rows:
=D1/INDEX(Calibration!G:G,
CEILING(ROW(),300)/300+1)
The divisor in the foregoing formula becomes Calibration!G2 for G1:G300, Calibration!G3 for G301:G600, Calibration!G4 for G601:G900, and so forth.