+ Reply to Thread
Results 1 to 7 of 7

How to adress cells correctly if rownumber and multiple colums are known.

  1. #1
    Registered User
    Join Date
    08-12-2017
    Location
    Almelo,Netherlands
    MS-Off Ver
    2016
    Posts
    10

    How to adress cells correctly if rownumber and multiple colums are known.

    Hello,

    In a worksheet I'd like to fill in formula's in only some rows.
    I can't figure out how to compose the cell adress in the formula.
    Thanks for your help.



    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: How to adress cells correctly if rownumber and multiple colums are known.

    Try:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: How to adress cells correctly if rownumber and multiple colums are known.

    Suspect this might work better:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    08-12-2017
    Location
    Almelo,Netherlands
    MS-Off Ver
    2016
    Posts
    10

    Re: How to adress cells correctly if rownumber and multiple colums are known.

    Thanks for your help, so far.
    Is there a way so the result in the cell is a formula and not a value. For example in cell N5: "=E5*M5"

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: How to adress cells correctly if rownumber and multiple colums are known.

    That would be:

    Please Login or Register  to view this content.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: How to adress cells correctly if rownumber and multiple colums are known.

    And the original, modified:

    Please Login or Register  to view this content.

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,087

    Re: How to adress cells correctly if rownumber and multiple colums are known.

    Thanks for the rep.

+ 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. Adding multiple cells from different colums and then ordering them
    By balexander1978 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-06-2015, 02:29 AM
  2. Combo Box with 2 colums, not displaying correctly
    By DM2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2015, 05:45 PM
  3. Sum column cells across multiple colums
    By woodland81 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-12-2014, 08:08 AM
  4. Match cells in multiple colums
    By TSFleming in forum Excel General
    Replies: 2
    Last Post: 10-02-2012, 10:55 PM
  5. sum multiple cells in the same row that are in colums with the same fieldname
    By johnnymac1971 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2012, 05:24 PM
  6. Formula required for comparing multiple colums to multiple colums
    By Pringgles in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2012, 07:23 AM
  7. rownumber as a value in a cel
    By fledermaus in forum Excel General
    Replies: 5
    Last Post: 11-23-2006, 05:02 PM

Tags for this Thread

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