Closed Thread
Results 1 to 4 of 4

find if any two adjacent numbers <=65 in a range

  1. #1
    Registered User
    Join Date
    11-08-2017
    Location
    miami, florida
    MS-Off Ver
    2010
    Posts
    35

    find if any two adjacent numbers <=65 in a range

    Test Scores.xlsx
    i think the thread title explains what i want. L3 should say 2 if there are any 2 adjacent numbers less than 66 in B3:K3.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2007
    Posts
    4,671

    Re: find if any two adjacent numbers <=65 in a range

    In L3:

    Please Login or Register  to view this content.
    =1: 1 adjacent couple
    =2: 2 adjacent couples
    and so on...

  3. #3
    Registered User
    Join Date
    11-08-2017
    Location
    miami, florida
    MS-Off Ver
    2010
    Posts
    35

    Re: find if any two adjacent numbers <=65 in a range

    thanks alot.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    16,655

    Re: find if any two adjacent numbers <=65 in a range

    Duplicate thread closed - do not open duplicates in future.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

Closed 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