Results 1 to 6 of 6

How to define data range index from number in another cell?

Threaded View

  1. 06-21-2020, 09:47 AM #1
    rcurious
    rcurious is offline
    Registered User
    Join Date
    07-03-2010
    Location
    Lithuania
    MS-Off Ver
    Excel 2016
    Posts
    83

    How to define data range index from number in another cell?

    Hello,

    How to define data range index from number in another cell? Whatever number I will write in that cell - SUM range will adjust to it.
    1.PNG
    Attached Files Attached Files
    Last edited by rcurious; 06-21-2020 at 09:56 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Needing Code to define range through the end of the number or rows present in the sheet.
    By computergecko in forum Excel General
    Replies: 6
    Last Post: 01-17-2017, 11:44 AM
  2. Index formula calling define name with non-adjacent range
    By haidan85 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2013, 05:49 AM
  3. Define range to select from current cell in a full range (using worksheet_change)
    By draddy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2013, 11:48 AM
  4. [SOLVED] Define a range of fixed number of columns, but unlimited number of rows
    By ccopac in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-22-2012, 02:23 PM
  5. INDEX formula to define column based on cell value
    By boohah in forum Excel General
    Replies: 2
    Last Post: 02-02-2011, 05:26 AM
  6. input number to define range
    By ghynes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2007, 06:01 AM
  7. [SOLVED] How to get an index of cell number in selction range.
    By mar_male@wp.pl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2006, 12:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1