Results 1 to 2 of 2

Min if not zero with another condition

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-09-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    390

    Min if not zero with another condition

    Hi All,

    I am looking for a way to find a min non-zero value in a range with another condition. for example I have a range with names (ColE) and a range with numbers (ColF) so I would like to find a Min value after 0 in ColF for a name in Cell B1 within ColE. I use the following formula to get the Min value after 0 in the whole range. How could I update it to add nother condition to get the non-zero Min value within the name of cell B1. Thanks

    Formula: copy to clipboard
    =SMALL(F1:F10,COUNTIF(F1:F10,0)+1)
    Last edited by hanif; 04-20-2021 at 09:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 19
    Last Post: 05-21-2019, 03:17 PM
  2. [SOLVED] Condition Forumula if Columns have Strings and if they match to preset condition
    By rosn.dhakal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-02-2018, 10:57 PM
  3. [SOLVED] Rotate List of names bottom to top Repeat without condition with option to set a condition
    By spyac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2018, 05:17 PM
  4. Replies: 7
    Last Post: 06-01-2015, 06:05 PM
  5. Condition formatting of multiple condition formatted cells
    By merrin84 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-22-2015, 05:08 PM
  6. [SOLVED] Help for if condition formula result only either hit or miss from mulitple condition
    By breadwinner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2013, 07:29 AM
  7. multi condition format? lookup and date condition valid for.
    By D_Rennie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-13-2009, 11:37 AM

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