Results 1 to 7 of 7

Dynamically updating last 12 entries. Does not seem to work.

Threaded View

  1. 06-02-2011, 09:31 PM #1
    welchs101
    welchs101 is offline
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,669

    Dynamically updating last 12 entries. Does not seem to work.

    I have this sheet (see enclosed file).

    I am using this formula to show the last several rows but it does not work.......dont know why?

    INDEX(Sheet1!A:A,MATCH(10000000000000000,Sheet1!$A:$A)-12+ROWS(Sheet1!$A$1:$A1))
    can some one help me?

    i have used this type of thing before but for some reason its not working this time.
    Attached Files Attached Files
    Last edited by welchs101; 06-02-2011 at 10:10 PM.
    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)

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