+ Reply to Thread
Results 1 to 12 of 12

Latest non blank cell value

  1. #1
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    254

    Latest non blank cell value

    Hi,

    I have a case, when I have a range of months which has its own coreposning amount.

    for example year 2012, which has its 12 months spread horizontally and each month has its value, home months, are missing amount for example there is aamount in january or february, but not in other months, I need to extract from this rows the latest non blank cell. not the last cell and not the first one, but the latest no blank cell.

    for example one row has amount in January and March, and another in february and august, I need the latest amount from each one, in first case from AMrch and in second case from August.

    please help, if needed I will upload a sample file..
    Last edited by G.Bregvadze; 04-12-2013 at 02:56 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,139

    Re: Latest non blank cell value

    By all means, upload a sample sheet.
    But maybe this site offers the wanted solution?

  3. #3
    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: Latest non blank cell value

    ..please help, if needed I will upload a sample file..
    It will be useful. Specially to see how your data looks like..
    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.

  4. #4
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    254

    Re: Latest non blank cell value

    I attached file

    111.xlsx

  5. #5
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    254

    Re: Latest non blank cell value

    Are there any suggestions?

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,139

    Re: Latest non blank cell value

    1. Have you opened the link I provided?
    2. Forum rules suggest you wait about 24 hr before bumping

  7. #7
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    254

    Re: Latest non blank cell value

    Yes I opned it but As I mentioned im my first post I need the latest value, not the last value, the formulas which are provided in the web page, return the last non-blank cell in row range. for example only from December 2012.

  8. #8
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    254

    Re: Latest non blank cell value

    Sorry, for bumping, I jsut needed the formula quickly, so if there is any solution, please help, thanks all in advance.

  9. #9
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,136

    Re: Latest non blank cell value

    hi G.Bregvadze, try this in Q4:
    =LOOKUP(2,1/(E4:P4<>0),E4:P4)

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  10. #10
    Forum Contributor G.Bregvadze's Avatar
    Join Date
    12-06-2012
    Location
    Georgia
    MS-Off Ver
    Excel 2010 - 2016
    Posts
    254

    Re: Latest non blank cell value

    Thank you so much, thanks a lot, the exact solution,

    I tried many combinations of lookup and index and other widely spread functions, but the result was always the same I got only the last value of the array. But I needed the latest value from array. thanks again for help an support. thanks

  11. #11
    Valued Forum Contributor wenqq3's Avatar
    Join Date
    04-01-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    868

    Re: Latest non blank cell value

    Quote Originally Posted by benishiryo View Post
    hi G.Bregvadze, try this in Q4:
    =LOOKUP(2,1/(E4:P4<>0),E4:P4)
    Interesting, can you do some explain.Thank you.
    =LOOKUP(2,1/(E4:P4<>0),E4:P4) --> why is 2?
    =LOOKUP(2,1/(E4:P4<>0),E4:P4) --> <> meaning?
    =LOOKUP(2,1/(E4:P4<>0),E4:P4) --> how to divide?
    -If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".

    -Always upload a workbook before start your question
    To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

    +++ If my answer(s) helped you, please add me reputation by click on * +++

  12. #12
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,139

    Re: Latest non blank cell value

    There is an explanation at this site - Good luck

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1