Results 1 to 5 of 5

Last Value

Threaded View

  1. 08-09-2009, 09:44 AM #1
    Ian3296e
    Ian3296e is offline
    Registered User
    Join Date
    08-09-2009
    Location
    Brentwood, TN
    MS-Off Ver
    Excel 2007
    Posts
    2

    Last Value

    =INDEX(B2:F2,1,MAX(IF(B2:F2<>"",COLUMN(B2:F2)))-COLUMN(B2)+1)

    I have used the above formula - it is exactly what i want but i am getting a #VALUE result. What have i done wrong?

    Moved to correct forum, added link to thread being referenced.

    http://www.excelforum.com/tips-and-t...-in-a-row.html
    Last edited by Paul; 08-10-2009 at 04:48 PM. Reason: Moved to correct forum
    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