+ Reply to Thread
Results 1 to 3 of 3

detect the adjacent to the left and right of a number.

  1. 09-15-2020, 08:05 AM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    detect the adjacent to the left and right of a number.

    detect the adjacent to the left and right of a number.
    the numbers 25 its adjacent 01 and vice versa or itself, in the others it is a number to the left and another to the right
    example draw 15 adjacent 14 x 16
    https://www.excelforum.com/attachmen...1&d=1600171491
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-15-2020, 10:20 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: detect the adjacent to the left and right of a number.

    Your result for RHS is incorrect....
    03 04 06 07 10 11 12 14 15 17 19 21 24 01

    Should be...
    03 04 06 07 10 11 12 14 15 17 19 21 24 25 01


    Please Login or Register  to view this content.
    Last edited by sintek; 09-15-2020 at 10:23 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 09-15-2020, 03:37 PM #3
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,175

    Re: detect the adjacent to the left and right of a number.

    ok , perfect conglatulations!! thank you!!
    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. Sum all numbers below if left of adjacent value is number
    By PaulM100 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-03-2020, 01:07 PM
  2. [SOLVED] detect the upper (+1) and lower (-1) adjacent of the draw line reference.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2019, 06:27 PM
  3. Detect and remove phone number in cells that contains string and number
    By farisnaufghas in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-07-2018, 05:34 PM
  4. [SOLVED] calculate on each row of the left and right adjacent draw, and see the number of digits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 34
    Last Post: 12-30-2017, 02:43 PM
  5. How to detect mouse left click on the screen with vba
    By recorded in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2015, 12:52 PM
  6. Using match and left function to detect fraud
    By chelsea99 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-22-2014, 11:41 PM
  7. To print non adjacent columns to all the pages in left
    By mithunphilip in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2013, 06:26 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1