+ Reply to Thread
Results 1 to 7 of 7

Check if value has been exceeded

Hybrid View

ppataki Check if value has been... 06-24-2011, 07:19 AM
teylyn Re: Check if value has been... 06-24-2011, 07:45 AM
martindwilson Re: Check if value has been... 06-24-2011, 07:46 AM
ppataki Re: Check if value has been... 06-24-2011, 07:53 AM
martindwilson Re: Check if value has been... 06-24-2011, 07:56 AM
teylyn Re: Check if value has been... 06-24-2011, 08:09 AM
ppataki Re: Check if value has been... 06-24-2011, 08:37 AM
  1. #1
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Check if value has been exceeded

    try this array formula

    =MIN(IF(B5:H5>M3,COLUMN(B5:H5)-1,""))

    you need to confirm it with CTRL-SHIFT-ENTER

    It will tell you the position of the smallest number that is greater than the value in M3.

    So, if E5=55 and F5=66, the result will be 4, because E5 is the smallest number that is greater than the 50 in M3.

    cheers,
    Last edited by teylyn; 06-24-2011 at 08:20 AM.

+ 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