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
Please help.
Sid