Having formula only calculate using fields of current row

smth333

New Member
Joined
Feb 17, 2004
Messages
1
I have a speadsheet where cols. A to N have headers in row 1. These headers are Name, Address etc. Columns D thru N contain values , manually entered for each record, and so can vary, e.g. In Col D ZIP codes are entered. Col G uses a list of values etc. 10 Separate calculations are performed in COL R, e,g R2 is given a valued depending on the value of the ZIP CODE entered in D. R4 is given a value dependent on the value entered in E, R6 calculates a value dependent on the value typed in F etc. I want these values calculated regardless of the row that is populated. By this I mean if I enter the first record, all the data entered will be for Row 2, the formulas correctly calculate the 10 values in Col R for the first record in row 2, however when I enter data for a second record in row 3, or a third record in row 4, the calculations are ignored, and only work for the first recod in row 2. How Can I get COL R (10 separate calculations;formulas) to execute these formulas for the row in which I'm currently entering data. That is if I'm entering data for my fifth record in row 6, I want the values in row 6 used in my formulas, If I'm entering data for my 3rd record in row 4, I want the data in row 4 used in my calculations, etc.

Please help.

Sid
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
Re: Having formula only calculate using fields of current ro

Something along these lines? [ Assumes the following -- Column D is the triger for changing rows and column D in numeric. If column D is text, change 999999 to REPT("z",255). ]
Book1
DEFGHI
1ZIPCodeValue1Value2Valuexcol-R
299999abc123q2q1368
367564xyz456w3w
Sheet2
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,939
Messages
5,856,409
Members
431,812
Latest member
Elastomers

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top