+ Reply to Thread
Results 1 to 9 of 9

help in excel, detect the largest and smallest digit of pick3 zero is the smallest digit *

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

    help in excel, detect the largest and smallest digit of pick3 zero is the smallest digit *

    help in excel, detect the largest and smallest digit of pick3 zero is the smallest digit
    * example
    456
    489
    156
    014
    at 456, the double of the position is 1.3
    we have three positional doubles
    * 1,2,1,3, 2,3 possible to be the smallest and largest
    * inside pick3, also the macro needs to make the location to be the first or second of the pair
    * ex
    489 = 1.3, smallest digit in the first position of the pair and largest in the 2nd position
    but in this example =
    971 = 1.3 the largest (9) digt is in 1st position
    * need someone in excel

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,436

    Re: help in excel, detect the largest and smallest digit of pick3 zero is the smallest dig

    Sorry what is Pick3?
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,620

    Re: help in excel, detect the largest and smallest digit of pick3 zero is the smallest dig

    hello,MEH, is lottery pick3
    https://www.excelforum.com/attachmen...1&d=1582846995
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,620

    Re: help in excel, detect the largest and smallest digit of pick3 zero is the smallest dig

    hello on the pick3 list, itís just an example every week Iíll put new draws the macro has to do automatically, when there are twin
    * 00,11,22,33,44,55,66,77,88,99, the macro does not
    * ex = 448, or 551 ...

  5. #5
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,436

    Re: help in excel, detect the largest and smallest digit of pick3 zero is the smallest dig

    Sorry

    I have looked at your file and read your posts. i understood nothing.

    Please Start with the basics and explain what you need example:

    1. Create 6 Random Numbers Between 1 and 50. Making Sure there are no Duplicates.

    2. Sort the numbers in Numerical Order.

  6. #6
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,620

    Re: help in excel, detect the largest and smallest digit of pick3 zero is the smallest dig

    objective = locate the smallest and largest digit of pick3, within the positions consequently
    * will have the 3rd as being average

  7. #7
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,406

    Re: help in excel, detect the largest and smallest digit of pick3 zero is the smallest dig

    F6:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Copy down. Similar formulas for columns G and E
    L6:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    M6:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Copy down. Similar formulas for columns I:J and O:P
    Attached Files Attached Files
    Best Regards,

    Kaper

  8. #8
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,620

    Re: help in excel, detect the largest and smallest digit of pick3 zero is the smallest dig

    ok, kaper, very good dissection work, from the smallest major pattern in pick3, great work in excel, if i know the positions of the major and minor pair,
    * I will have more chances of predicting pick3 in the 720 pick3 formations, thanks for the hard work

  9. #9
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    7,406

    Re: help in excel, detect the largest and smallest digit of pick3 zero is the smallest dig

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    I was sure you were already aware of it.

    Also, you thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. Pulling the smallest digit from a 3 digit cell
    By khank in forum Excel General
    Replies: 6
    Last Post: 01-17-2020, 09:10 PM
  2. largest, smallest, 2nd largest & 2nd smallest
    By bittubadri in forum Excel General
    Replies: 27
    Last Post: 11-03-2019, 12:14 AM
  3. [SOLVED] separate the last digit into threes, then detect one of the 6 largest patterns.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-27-2019, 09:54 AM
  4. [SOLVED] autosorting largest to smallest
    By andrugrasu in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-31-2017, 03:39 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. Sort largest to smallest - VBA
    By Ricardo Mass in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2013, 09:05 AM
  7. 3 largest qty and 3 smallest
    By geng in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2010, 12:20 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