+ Reply to Thread
Results 1 to 5 of 5

to detect double and triple strings last digit

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,169

    to detect double and triple strings last digit

    to detect double and triple strings
    last digit
    separate the last digits from 0 to 9
    * then you will detect double and triple digit
    * in each draw line please
    https://www.excelforum.com/attachmen...1&d=1560170408
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: to detect double and triple strings last digit

    You need to spend more time explaining what you are looking for.

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,169

    Re: to detect double and triple strings last digit

    Ok DAVE, step 1, you have to separate
    the last digits of the draw line
    ex = 17 the digit 7 is last digit
    Step 2 add the number of digits to form the string, let's assume that after separating the last 15
    digit we have the digit 6 repeated twice then it
    is 66 another ex = if it has 3 digits 4 then it is in the string
    444
    ie the macro or formula will add up to the amount of
    of digits

  4. #4
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: to detect double and triple strings last digit

    In AG6, enter:

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Copy across / down.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  5. #5
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,169

    Re: to detect double and triple strings last digit

    ok OLLY, perfect, conglatutations, thank you!!!

+ Reply to 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 4 patterns * after separating the last digit
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-21-2019, 10:38 AM
  2. please detect the last digit and add up the amount of times.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2019, 07:41 AM
  3. [SOLVED] Macro to convert WBS single digit numbers to double digit numbers
    By LeanAccountant in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 06-09-2018, 05:25 AM
  4. [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
  5. separate possible triple digit formations without repetition of 60/6
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-17-2014, 12:02 PM
  6. Replies: 3
    Last Post: 12-05-2012, 05:12 PM
  7. Replace 'Double or Triple Spaces
    By hardeep.kanwar in forum Word Formatting & General
    Replies: 2
    Last Post: 07-19-2010, 02: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1