+ Reply to Thread
Results 1 to 4 of 4

Looking up the lowest populated value in an array

  1. 07-29-2016, 06:15 AM #1
    jamot
    jamot is offline
    Registered User
    Join Date
    07-29-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    1

    Post Looking up the lowest populated value in an array

    I am trying to lookup the value contained in the lowest populated row of an array of data.

    So far I have been using LOOKUP(2,1 /(NOT(ISBLANK(B2:B12))),B2:B12) which has been working fine.

    I now want to formulate B2:B12 with an if statement that makes them blank if another cell is empty. At this point the Lookup formula does not function anymore and will return the blank from B12. Any ideas on how to adjust the formula when the reference cells themselves work off a formula? Any help would be much appreciated. Thanks!
    Reply With QuoteRegister To Reply
  2. 07-29-2016, 06:16 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    81,091

    Re: Looking up the lowest populated value in an array

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-29-2016, 06:19 AM #3
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: Looking up the lowest populated value in an array

    Perhaps

    Try

    =MIN(IF(B2:B12<>"",B2:B12)) with control+shift+enter.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  4. 07-29-2016, 08:37 AM #4
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Looking up the lowest populated value in an array

    If I understand what you want try this...

    =LOOKUP(2,1/(B2:B12<>""),B2:B12)
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Lowest value in array to a cell
    By cocacrave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-19-2015, 12:32 AM
  2. Find Max Date from an array populated by variables
    By SheldonVBA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-15-2014, 07:25 AM
  3. Finding the last populated cell in a column array
    By JosephJames in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-18-2009, 12:42 PM
  4. How do I return the next lowest value in an array?
    By carnejm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-10-2008, 11:47 AM
  5. How find lowest value in an Array?
    By AnthonyC in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2008, 11:12 AM
  6. Array Value populated from cell A2:A38
    By Chris Baluyot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-22-2008, 02:04 AM
  7. [SOLVED] 2nd lowest number in an array
    By Greg in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-24-2006, 02:55 PM

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