help in excel, detect the largest and smallest digit of pick3 zero is the smallest digit   example 4Prev TopicNext Topic

• dr san

  

  bgonçalves
  Brasil
  Member #92,558
  June 9, 2010
  4,155 Posts
  Offline
  Feb 27, 2020, 6:27 pm

  ▲▼

  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
• dr san

  

  bgonçalves
  Brasil
  Member #92,558
  June 9, 2010
  4,155 Posts
  Offline
  Feb 27, 2020, 7:08 pm

  ▲▼

  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 ...
• Todd

  

  50

  Chief Bottle Washer

  New Jersey
  United States
  Member #1
  May 31, 2000
  28,845 Posts
  Online
  Feb 27, 2020, 8:42 pm

  ▲▼

  <Moved to Lottery Discussion forum>

  Please post in the appropriate forum ... thank you.
• nibor200

  

  United States
  Member #203,631
  January 11, 2020
  19 Posts
  Offline
  Feb 28, 2020, 10:13 am

  ▲▼

  @Todd,

  Shouldn’t Excel questions be in Mathematics forum.?

  Thanks,

  Ed S.
• Todd

  

  50

  Chief Bottle Washer

  New Jersey
  United States
  Member #1
  May 31, 2000
  28,845 Posts
  Online
  Feb 28, 2020, 10:17 am

  ▲▼

  No, Excel is not math.  It is software.  Many people use Excel for things that have nothing to do with math, and in fact this particular thread's topic about using Excel has nothing to do with math.

  If there is a question about a math formula being developed in Excel (or any other software), that would be something for the math forum.

   

  Check the State Lottery Report Card
  What grade did your lottery earn?

   

  Sign the Petition for True Lottery Drawings
  Help eliminate computerized drawings!