+ Reply to Thread
Results 1 to 7 of 7

detect the presence of the numbers from 09 to 16

  1. 04-28-2020, 09:45 AM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,320

    detect the presence of the numbers from 09 to 16

    please=detect the presence of the numbers from 09 to 16
    https://www.excelforum.com/attachmen...1&d=1588081493
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-28-2020, 09:59 AM #2
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,108

    Re: detect the presence of the numbers from 09 to 16

    use
    =IF(COUNTIF($A5:$O5,Q$4)>0,"X",0)
    copy across and down

    I have also added conditional formating for
    Green if X
    Blue if 0

    I see you are in the VBA forum, so may not want a function/formula reply and prefer a VBA solution as given now
    Attached Files Attached Files
    Last edited by etaf; 04-28-2020 at 10:09 AM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 04-28-2020, 10:06 AM #3
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: detect the presence of the numbers from 09 to 16

    Hi jorel,

    How about:

    Please Login or Register  to view this content.
    EDIT: I see now there was another reply using the same idea, but I know you usually prefer VBA instead of formulas. If you don't need VBA then use the other solution
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
  4. 04-28-2020, 10:19 AM #4
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: detect the presence of the numbers from 09 to 16 

    Please Login or Register  to view this content.
    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 [★ Add Reputation] to left of post window...
    Also....Add a comment if you like!!!!
    And remember...Mark Thread as Solved...
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  5. 04-28-2020, 11:03 AM #5
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,320

    Re: detect the presence of the numbers from 09 to 16

    hello. etaf. arkadi and sintek, correct,thank you!
    Reply With QuoteRegister To Reply
  6. 04-28-2020, 12:23 PM #6
    Sintek
    Sintek is offline
    Forum Guru Sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2019 | 2021
    Posts
    14,958

    Re: detect the presence of the numbers from 09 to 16

    .........................
    THANKS.gif
    Reply With QuoteRegister To Reply
  7. 04-28-2020, 12:26 PM #7
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: detect the presence of the numbers from 09 to 16

    Thanks for the feedback jorel, and for the rep, and for marking the thread as closed
    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. [SOLVED] detect the presence of the number * from 7 to 19.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-24-2019, 07:37 AM
  2. [SOLVED] detect code 6,7,8,9. well we have 8 possible numbers .
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-30-2019, 08:05 AM
  3. [SOLVED] Detect the presence of the double of the last digit, after separating the lasts type of th
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-01-2018, 07:15 PM
  4. Detect the presence of data in specific cell range and update table in another sheet
    By ell_ in forum PowerPoint Programming
    Replies: 6
    Last Post: 01-23-2018, 08:09 PM
  5. Detect the presence of data in specific cell range and update table in another sheet
    By ell_ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2018, 08:31 PM
  6. Detect numbers in a cell range and then change cells based on what numbers are found
    By scum in forum Excel General
    Replies: 7
    Last Post: 02-27-2014, 10:56 PM
  7. Detect Negative numbers
    By new@this in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2007, 05:30 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