+ Reply to Thread
Results 1 to 4 of 4

Copying formula on entire column, adjusting some values but keeping some the same

  1. #1
    Registered User
    Join Date
    06-28-2014
    Location
    Texas
    MS-Off Ver
    Idk
    Posts
    2

    Copying formula on entire column, adjusting some values but keeping some the same

    My title might be confusing because im not sure how to express what im trying to do in a sentence but basically i have this formula
    Please Login or Register  to view this content.
    I need B# to change automatally like it does when you copy the formula but i need the N1 and N2 to stay N1 and N2, how do i do this?

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,022

    Re: Copying formula on entire column, adjusting some values but keeping some the same

    Do you mean like this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    06-28-2014
    Location
    Texas
    MS-Off Ver
    Idk
    Posts
    2

    Re: Copying formula on entire column, adjusting some values but keeping some the same

    yes that exactly, thanks!

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,022

    Re: Copying formula on entire column, adjusting some values but keeping some the same

    can you then mark the thread as closed and (preferably) click the add Reputation button at the foot of the posts of all who helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copying the formula horizontaly keeping the same column but changing row number
    By ciapul12 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-15-2014, 02:05 PM
  2. [SOLVED] Help Copying an Array Formula down an Entire Column
    By dewitte in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-03-2014, 02:31 AM
  3. adjusting comment box size for an entire column
    By darkhorse4321 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2010, 10:36 AM
  4. Delete Entire Row, but keeping the Formula in tact
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-26-2008, 01:34 PM
  5. [SOLVED] keeping certain values the same when copying
    By Steve K in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-28-2005, 11:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1