• 100% Satisfaction Guarantee

Richard, Software Engineer
Category: Software
Satisfied Customers: 30136
Experience:  Software Systems Specialist.
32989067
Richard is online now

I want to change formula in row within excel. The formula

Resolved Question:

Hi
I want to change formula in row within excel. The formula is =Doors!\$H\$55*2. I want to change the letter from H to J and then change again when required. Using replace all changes all the H in entire spreadsheet to J. At the moment I am going down the row changing in cell individually but is there a way I can change the letter in the entire row without changing the letter anywhere else in spreadsheet
Regards
Terry
Submitted: 7 months ago.
Category: Software
Expert:  Richard replied 7 months ago.
Hi there and welcomeyou can use the indirect function for this.So you put in for example in cell A1 the value of HThen you use the function=indirect(Doors!\$ & A1 & "\$55)*2that way when you change H to G in A1, the formula will use G55 instead If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know. Else if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated. Thank you
Customer: replied 7 months ago.

Apologies I do not think I was clear in my question. The number changes throughout the row, so could be =Doors!\$H\$55*2 or =Doors!\$H\$55 or =Doors!\$H\$65 etc. Using the indirect function will it only change the letter ie the H to a J as example

Expert:  Richard replied 7 months ago.
ok, then you use the indirect for the number instead, so it would be=INDIRECT("Doors!H" & A1)*2Indirect is just used to reference a cell as part of the formula.
Customer: replied 7 months ago.

Sorry not getting this.If my formula is =Doors!\$H\$55 throughout the row with the column number changing from 10 to 324 to pick up the various values but when I use the formula in different spreadsheets the row letter changes. I have never used Indirect function or place & in formula. Do I leave original formula in and somehow use indirect function or is it new formula of =indirect("doors!\$H\$"&55)

H is column and various rows are used, dollar sign as LETTER is constant down row.Sorry if I am not making sense burt as I said not understanding

Expert:  Richard replied 7 months ago.
Sorry, I do not understand now what you are trying to explain.Initially you askedI want to change formula in row within excel. The formula is =Doors!\$H\$55*2. I want to change the letter from H to J and then change again when requiredThen you indicated The number changes throughout the row, so could be =Doors!\$H\$55*2 or =Doors!\$H\$55 or =Doors!\$H\$65 etc. But this last explanation I do not understand at all. Can you try to please provide me a very clear description of what it is you require Terry?Thank you
Expert:  Richard replied 7 months ago.
.
Richard, Software Engineer
Category: Software
Satisfied Customers: 30136
Experience: Software Systems Specialist.
Customer: replied 7 months ago.

Ok, going down the row my formulas are as follows,

=Doors!\$H\$55*2

=Doors!\$H\$58

=Doors!\$H\$55*2

=Doors!\$H\$34*2

=Doors!\$H\$56

The formula pulls the information from different sheet called DOORS and I have columns ranging from C to Y with different prices in each column. I then have pages with the names of doors example being Gresham and Gresham requires the pricing from column H. Another page is called Boston and Boston requires the pricing from column G. So the only change in the formula as I move along the pages is the letter. So as I move from the Gresham page to the Boston page I want to change the letter from H to G but in the column only not everywhere in sheet as would happen if I select the replace function.

I hope this helps.

Expert:  Richard replied 6 months ago.
you would then need to manually change it through you have to do this to put in the sheet name as well

What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
< Previous | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.

• Steve Herrod

Satisfied Customers:

160
Familiar with a wide variety of software and experienced in user training/support
< Last | Next >

Steve Herrod

Satisfied Customers:

160
Familiar with a wide variety of software and experienced in user training/support

Chris L.

Satisfied Customers:

114
Certified Software expert with over 10 years experience.

Jess M.

Satisfied Customers:

109
Computer Software Support specialist for more that 10 years

Frederick S

Satisfied Customers:

91
Computer technician; founder of a home PC repair company.

Bernie

Satisfied Customers:

52
6+ years experience, Microsoft MCDST/CompTia A+ Certified

The-PC-Guy

Satisfied Customers:

38
20 years experience providing remote computer support