+ Reply to Thread
Results 1 to 9 of 9

Need a formula that looks for last column

  1. #1
    Forum Contributor
    Join Date
    01-14-2011
    Location
    New York City, USA
    MS-Off Ver
    Excel 2010
    Posts
    194

    Need a formula that looks for last column

    I'm trying to write a formula that will take the data from Sheet 2 of my weekly dashboard and place it in the appropriate cells in Sheet 1. This would be easy but the tricky part is that every week I add a new column on Sheet 2 so I really need a formula in Sheet 1 that looks for the last column in Sheet 2 to pull through the data.

    I'm having problems uploading to the forum so here's the example file:

    http://goo.gl/kFtkl

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Need a formula that looks for last column

    Hi

    Your columns have numbers or text?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Contributor
    Join Date
    01-14-2011
    Location
    New York City, USA
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Need a formula that looks for last column

    numbers

    thanks

  4. #4
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Need a formula that looks for last column

    You can get the last (rightmost) number from sheet1 row 2 with this formula

    =LOOKUP(9.99E+307,Sheet1!2:2)
    Audere est facere

  5. #5
    Forum Contributor
    Join Date
    01-14-2011
    Location
    New York City, USA
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Need a formula that looks for last column

    daddylonglegs, I think you're on the right track but it's not working in my situation. Can you try with my example workbook?

    http://goo.gl/kFtkl

  6. #6
    Forum Contributor
    Join Date
    01-14-2011
    Location
    New York City, USA
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Need a formula that looks for last column

    To all: I found my answer using this formula:
    Please Login or Register  to view this content.

  7. #7
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Need a formula that looks for last column

    You should be able to do that more simply with LOOKUP as per my suggestion

    =LOOKUP(9.99E+307,'sheet 2'!7:7)

  8. #8
    Forum Contributor
    Join Date
    01-14-2011
    Location
    New York City, USA
    MS-Off Ver
    Excel 2010
    Posts
    194

    Re: Need a formula that looks for last column

    Hey on a related note: does anyone know how to write a similar formula to auto-update Sparkline graphs based on the addition of a new column in the worksheet?

  9. #9
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    552

    Re: Need a formula that looks for last column

    You should post a new question in a different thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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