Results 1 to 6 of 6

The formula for the last number of the column (table)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-20-2016
    Location
    Los Angeles/Thailand
    MS-Off Ver
    2016
    Posts
    250

    The formula for the last number of the column (table)

    Hello, how are you? I use this code =LOOKUP(9.99999999999999E+307,A1:A50) for the last number of the column but this code does not work for a pivot table because the table always growing.

    What is a similar code that can work for a table column?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find Max Value in Table, Return Row & Column Number
    By roche92 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-25-2015, 04:47 PM
  2. What formula to use to match 1 number to mutiple number & column
    By vani2004 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2014, 01:29 PM
  3. [SOLVED] need formula to this logic, A column number B column blank then C column desired name
    By vengatvj in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-02-2013, 10:30 PM
  4. Replies: 7
    Last Post: 01-25-2013, 05:17 PM
  5. [SOLVED] Need a formula to sort a table into table (for a Table Plan) and name in column 2
    By jbpianoman in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2012, 09:21 AM
  6. Replies: 2
    Last Post: 02-13-2012, 09:03 AM
  7. How do I determine Table Column Index Number?
    By sauerj in forum Word Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2010, 09:25 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