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
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,464
Messages
5,601,817
Members
414,479
Latest member
Beau the dog

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