Results 1 to 3 of 3

Match Highest/Lowest Number

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Match Highest/Lowest Number

    Hello,
    Can anyone help me fix these formula so that when the number I'm searching for is "higher" than what's in the search parameter I don't get the #NUM! error? I'd be fine with it showing a negative number or zero. Thanks in advance.

    =IF(COUNTIF(A1:A5,B1)>=1,A1:A10,LARGE(A1:A5,COUNTIF(A1:A10,">"&B1)))

    =IF(COUNTIF(A1:A5,B1)>=1,A1:A10,SMALL(A1:A5,COUNTIF(A1:A10,"<"&B1)))

    A1: 5
    A2: 8
    A3: 9
    A4: 7
    A5: 1

    B1: 11
    Last edited by artiststevens; 11-29-2010 at 01:10 AM.

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