How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Engineer
Category: Software
Satisfied Customers: 33885
Experience:  Software Systems Specialist.
32989067
Type Your Software Question Here...
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: 1 year ago.
Category: Software
Expert:  Richard replied 1 year 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 1 year 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 1 year 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 12 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 12 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 12 months ago.
.
Richard, Software Engineer
Category: Software
Satisfied Customers: 33885
Experience: Software Systems Specialist.
Richard and 2 other Software Specialists are ready to help you
Customer: replied 12 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 12 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.
 
 
 

Meet The Experts:

 
 
 
  • Steve Herrod

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    160
    Familiar with a wide variety of software and experienced in user training/support
< Previous | Next >
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    160
    Familiar with a wide variety of software and experienced in user training/support
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    115
    Computer Software Support specialist for more that 10 years
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    114
    Certified Software expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/FS/fszcze/2012-6-18_181848_500test.64x64.jpg Frederick S's Avatar

    Frederick S

    Computer Specialist

    Satisfied Customers:

    91
    Computer technician; founder of a home PC repair company.
  • http://ww2.justanswer.com/uploads/WA/wa94sound/2012-6-6_202633_iStock000007010121Small.64x64.jpg Bernie's Avatar

    Bernie

    Software Support

    Satisfied Customers:

    52
    6+ years experience, Microsoft MCDST/CompTia A+ Certified
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Software Engineer

    Satisfied Customers:

    38
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/jnayes/2010-12-23_132454_japicbetter.jpg jnayes's Avatar

    jnayes

    Computer Support

    Satisfied Customers:

    37
    Network Administrator
 
 
 

Related Software Questions