+ Reply to Thread
Results 1 to 7 of 7

please detect the last digit and add up the amount of times.

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

    please detect the last digit and add up the amount of times.

    please detect the last digit
    and add up the amount of times.
    we have 6 different lotteries, I will always change
    the result, the macro will separate the last digits
    * and add up the number of times it was drawn
    * from 0 to 9
    https://www.excelforum.com/attachmen...1&d=1558028911
    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: please detect the last digit and add up the amount of times.

    Place this in CJ5 and drag it across
    Formula: copy to clipboard
    Please Login or Register  to view this content.

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

    Re: please detect the last digit and add up the amount of times.

    please, DAVE, I tried to do as indicated
    * did not work
    * Can you get inside the plane to download?

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

    Re: please detect the last digit and add up the amount of times.

    Here you go.
    Attached Files Attached Files

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

    Re: please detect the last digit and add up the amount of times.

    Okay,DAVE, that's correct, I need you to show it.
    * the separation of the last digits in each lottery

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

    Re: please detect the last digit and add up the amount of times.

    Use the =right() function to extract the last digit.

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

    Re: please detect the last digit and add up the amount of times.

    ok,DAVE, perfect, conglatulations, 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. detect in each group the number of times it was drawn
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-11-2019, 09:25 AM
  2. please detect the front double of the pick3 and see the amount of each groups.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2019, 10:01 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. [SOLVED] Round of 7 digit amount into 2 digit
    By hkbhansali in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-24-2016, 10:34 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. How to detect amount of changes in cell?
    By defy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-19-2010, 04:50 PM
  7. Replies: 3
    Last Post: 09-02-2008, 10:52 PM

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