+ Reply to Thread
Results 1 to 10 of 10

Separate the last digit and find the numbers tesla 3,6,9

  1. 07-09-2018, 11:50 AM #1
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,179

    Separate the last digit and find the numbers tesla 3,6,9

    Separate the last digit and find the numbers tesla 3,6,9
    https://www.excelforum.com/attachmen...1&d=1531151409
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-09-2018, 11:57 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    82,140

    Re: Separate the last digit and find the numbers tesla 3,6,9

    Please?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-09-2018, 12:02 PM #3
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,179

    Re: Separate the last digit and find the numbers tesla 3,6,9

    hello aligw, yes, yes England campeon. copa 2018 soccer
    Reply With QuoteRegister To Reply
  4. 07-09-2018, 12:05 PM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    82,140

    Re: Separate the last digit and find the numbers tesla 3,6,9

    Hello, Jorel. When are you going to start asking politely instead of demanding? Try showing a bit of respect in your opening posts, in particular, to those giving of their time freely to help you. Your posts are often curt: try spending a few seconds more to add the occasional "please" and "thank you". You have been a member here for long enough to know this: I should not have to point it out to you.
    Reply With QuoteRegister To Reply
  5. 07-09-2018, 12:06 PM #5
    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: Separate the last digit and find the numbers tesla 3,6,9

    Based on the format of the sample sheet:

    Please Login or Register  to view this content.
    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
  6. 07-09-2018, 12:06 PM #6
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,179

    Re: Separate the last digit and find the numbers tesla 3,6,9

    separate last digit= 6 7 3 5 8 9 9
    Reply With QuoteRegister To Reply
  7. 07-09-2018, 12:09 PM #7
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Separate the last digit and find the numbers tesla 3,6,9

    Try this:

    I5 =RIGHT(A5)+0
    Drag through O5 then down through row 24.

    Q5 =IF(COUNTIF($I5:$O5,Q$4),"x","")
    Drag through S5 then down through row 24.
    Reply With QuoteRegister To Reply
  8. 07-09-2018, 12:11 PM #8
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Separate the last digit and find the numbers tesla 3,6,9

    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    U
    4
    3
    6
    9
    5
    03
    05
    08
    09
    19
    21
    30
    3
    5
    8
    9
    9
    1
    0
    x
    x
    		 I5: =MOD(A5, 10)
    6
    08
    11
    12
    14
    20
    21
    28
    8
    1
    2
    4
    0
    1
    8
    		 Q5: =IF(COUNTIF($I5:$O5, Q$4), "x", "")
    7
    11
    12
    21
    24
    25
    28
    29
    1
    2
    1
    4
    5
    8
    9
    x
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  9. 07-09-2018, 12:11 PM #9
    jorel
    jorel is offline
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2016
    Posts
    2,179

    Re: Separate the last digit and find the numbers tesla 3,6,9

    ok [COLOR="#FF0000"]ark[/COLOR]adi, perfect, very good job, congratulations
    thank you !!
    Reply With QuoteRegister To Reply
  10. 07-09-2018, 12:15 PM #10
    63falcondude
    63falcondude is offline
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Separate the last digit and find the numbers tesla 3,6,9

    Thanks for the rep!
    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] 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
  2. How to find all 5-digit numbers within a single cell?
    By ericss42 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-13-2017, 03:49 PM
  3. Bank Recon - How to convert 8 digit formatted check numbers to 6 digit
    By Quisp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2017, 09:55 PM
  4. Macro to identify 3-digit and 4-digit numbers as valid dates
    By gojakie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2015, 08:16 AM
  5. [SOLVED] LOTTERY FILTER#4, Find if 1 Digit Sum of 2 Digit or 3 Digit, Single Cell w/ dash
    By david gonzalez in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2014, 12:57 AM
  6. Extract 4 digit common numbers from 5 digit numbers
    By ameque in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-24-2013, 01:09 AM
  7. [SOLVED] macro to extract 9 digit numbers as well as alpha numberic 9 digit numbers from txt file
    By Raju Radhakrishnan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2012, 10:15 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