+ Reply to Thread
Results 1 to 3 of 3

Finding and using last line number in an equation.

  1. #1
    Registered User
    Join Date
    07-27-2021
    Location
    Weston-super-Mare
    MS-Off Ver
    365 Apps
    Posts
    17

    Finding and using last line number in an equation.

    Hi,

    I have a table that grows as new information is added. On this table I run various calculations and pivot tables.

    Other than saying Column A:A is there any way to have a range from A2:A(last line number) in my equations, where the last line number is the length of the table.

  2. #2
    Valued Forum Contributor
    Join Date
    07-13-2021
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    513

    Re: Finding and using last line number in an equation.

    Perhaps:

    A2:INDEX(A:A,MATCH(1E300,A:A))

    1E300 (Excel displays 1E+300) is any "large number", greater than any reasonable number in the column.

    I like 1E300 or 1E100 because they are easy to remember.

    -----

    Some people insist on using 9.99999999999999E307, incorrectly stating that that is the "largest possible" number.

    That is indeed the largest constant that we can enter manually. But it is not the largest value that can be calculated.

    So there is really little point in trying to remember such as arcane number, unless you truly expect people to manually enter values in that numerical range.

  3. #3
    Registered User
    Join Date
    07-27-2021
    Location
    Weston-super-Mare
    MS-Off Ver
    365 Apps
    Posts
    17

    Re: Finding and using last line number in an equation.

    Thank you for taking the time to reply.

    I had found that bit of code searching on-line. I was hopeful there was a built in command I had not found, it feels like MS has missed a trick here.

+ 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] Finding value of X to satisfy equation
    By jpe1 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-01-2019, 04:16 AM
  2. Replies: 4
    Last Post: 09-03-2011, 06:54 PM
  3. Finding a best fit constant for a given equation
    By fsapienza in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-04-2011, 10:39 AM
  4. Replies: 2
    Last Post: 03-07-2011, 06:29 PM
  5. Finding text in an equation
    By HelenStrand in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2008, 01:53 AM
  6. equation of a line
    By gbrown1 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-12-2007, 12:53 PM
  7. Trend Line - Equation
    By Rich 80105 in forum Excel General
    Replies: 3
    Last Post: 06-03-2006, 04:10 AM

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