+ Reply to Thread
Results 1 to 4 of 4

How to insert a Row() function inside a RIGHT function

  1. #1
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Panama City, FL
    MS-Off Ver
    Excel 2016
    Posts
    175

    How to insert a Row() function inside a RIGHT function

    Hello friends,
    I'm using the following formula, but to copy in multiple times down the column, I need the Row to change accordingly.
    Please tell me how I can replace the RED 24 with "ROW()".

    Please Login or Register  to view this content.
    Thanks so much!

  2. #2
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: How to insert a Row() function inside a RIGHT function

    Since it's not between sets of quotes, it should automatically change as you drag down. I did a quick test, and it changed for me as I dragged down. Is that not happening for you?
    If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.

    If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.

  3. #3
    Forum Contributor
    Join Date
    06-08-2012
    Location
    Panama City, FL
    MS-Off Ver
    Excel 2016
    Posts
    175

    Re: How to insert a Row() function inside a RIGHT function

    Thank you so much for [the Obvious]. I guess when working on trying to figure out the *complicated* way to do it I [using row()] overlooked the *obvious* and easier way.
    I appreciate your time and reply.

  4. #4
    Valued Forum Contributor
    Join Date
    01-07-2013
    Location
    Michigan
    MS-Off Ver
    O365
    Posts
    601

    Re: How to insert a Row() function inside a RIGHT function

    I find myself overcomplicating things (especially in Excel) all the time. Thanks for the rep, and good luck!

+ 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. INDIRECT/ADDRESS inside LINEST function versus inside INTERCEPT
    By slny06 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2019, 08:51 AM
  2. Replies: 5
    Last Post: 07-05-2018, 02:50 PM
  3. Replies: 2
    Last Post: 07-03-2018, 02:26 PM
  4. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  5. Replies: 11
    Last Post: 06-01-2015, 02:21 AM
  6. Replies: 0
    Last Post: 01-19-2013, 01:35 PM
  7. [SOLVED] Using ROW function inside of both an Indirect and Index function returns #VALUE
    By xandermacleod in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-11-2012, 06:22 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