+ Reply to Thread
Results 1 to 3 of 3

nth non blank cell value smaller than

  1. 04-13-2021, 08:36 PM #1
    Excl3454
    Excl3454 is offline
    Registered User
    Join Date
    01-29-2021
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    93

    nth non blank cell value smaller than

    hello,
    wondering if someone can help me how to get nth non black number that are smaller or equal and greater than?
    Thank you so muchscreenshot.6060.jpg
    Attached Files Attached Files
    Last edited by Excl3454; 04-14-2021 at 05:29 PM.
    Reply With QuoteRegister To Reply
  2. 04-13-2021, 09:55 PM #2
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: nth non blank cell value smaller than

    1st smaller than 10:

    Please Login or Register  to view this content.
    1st smaler than 20 and greater than 10:

    Please Login or Register  to view this content.
    Quang PT
    Reply With QuoteRegister To Reply
  3. 04-14-2021, 12:47 AM #3
    Excl3454
    Excl3454 is offline
    Registered User
    Join Date
    01-29-2021
    Location
    Canada
    MS-Off Ver
    2019
    Posts
    93

    Re: nth non blank cell value smaller than

    Quote Originally Posted by bebo021999 View Post
    1st smaller than 10:

    Please Login or Register  to view this content.
    1st smaler than 20 and greater than 10:

    Please Login or Register  to view this content.
    many thanks,,very nice of you...
    very quick and good solution,
    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] nth non blank cell value smaller than
    By Excl3454 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-14-2021, 03:32 AM
  2. [SOLVED] Finding smaller of two non-sequentiual cell values
    By MikeyChris in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-17-2018, 04:31 AM
  3. [SOLVED] Fast way to move down a column until active cell is smaller than the previous cell value
    By herbie226 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-09-2014, 05:44 AM
  4. How to find value and address of first cell in a range that is smaller than X?
    By hadamhiram in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-26-2013, 09:40 PM
  5. Show if cell is greater or smaller than previous value
    By holmwood in forum Excel General
    Replies: 12
    Last Post: 11-16-2009, 06:12 AM
  6. VBA to delete row if value in cell is larger or smaller than a specified value
    By judasdac in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2009, 02:54 PM
  7. Why do my checkboxes get smaller and smaller every time they are checked?
    By q-tip in forum Excel General
    Replies: 1
    Last Post: 09-21-2008, 01:36 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1