Hi,
The excel sheet I am uploading has 100 columns that each need to be divided by it's respective column
The set up right now is columns 1-100 are the numerators and columns 101-200 are the denominators so the formula would be along the lines of:
field 1 / field 101 = new column A
field 2 / field 102 = new column B
field 3 / field 103 = new column C
etc.
I'm wondering if there is a better way to do it than manually entering all 100 formulas - maybe by utilizing the multi field formula?
Attached is an example of how my data is set up in Excel
Thanks,
Lauren
Solved! Go to Solution.