+ Reply to Thread
Results 1 to 9 of 9

separate the 5 threes * and then make the difference between * 1st and 3rd digits.

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

    separate the 5 threes * and then make the difference between * 1st and 3rd digits.

    separate the 5 threes
    * and then make the difference between
    * 1st and 3rd digits (first and last of trio)
    of each crack, the middle digit
    * not only the first and last
    * of each threesome make your difference
    and ride the positional suit
    https://www.excelforum.com/attachmen...1&d=1564772234
    Attached Files Attached Files

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

    Re: separate the 5 threes * and then make the difference between * 1st and 3rd digits.

    hello, error 5º trio 23 24 25 corret value= 2 ok 23- 25 = corret 2

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

    Re: separate the 5 threes * and then make the difference between * 1st and 3rd digits.

    hello sorry!!! corret=
    https://www.excelforum.com/attachmen...1&d=1564776872
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,861

    Re: separate the 5 threes * and then make the difference between * 1st and 3rd digits.

    I feel like I am missing something. What are the exact programming details that you need the spreadsheet to perform? You have posted this in the VBA section -- what do you need VBA to do and what do you need the spreadsheet to do?

    That said, here's how I would build that spreadsheet -- without any VBA:

    0) Starting with columns A:O
    1) In Q6, enter =A6 and copy/paste/fill into Q6:AE6
    2) Select column AC and insert column. Repeat for column Z, W, T.
    3) In the newly created empty column T, enter =S6-Q6. Copy T6 and paste into X6, AB6, AF6, AJ6
    4) To get the summary table off to the right, AM6 =T6, AN6 =X6, AO6 =AB6, AP6 =AF6, AQ6 =AJ6.
    5) Select Q6:AQ6 and copy/paste/fill down.

    It seems nor more difficult than that. Is there something I have misunderstood?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: separate the 5 threes * and then make the difference between * 1st and 3rd digits.

    hello,MrSHORTY, thanks for the hard work,
    I tried to translate the formulas in Portuguese but it did not work, you can put in the plain
    * to download please

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,861

    Re: separate the 5 threes * and then make the difference between * 1st and 3rd digits.

    It will be a couple of days before I can upload a sheet.
    I tried to translate the formulas in Portuguese but it did not work
    I am a little surprised, because I thought subtraction would be indicated by - in Portuguese as well, and the = sign to start any formula would also still be the same. If you tell me what your version of Excel uses for the subtraction and formula= operators, I'm sure I could more quickly edit the formulas in my post to use those operators.

  7. #7
    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. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,444

    Re: separate the 5 threes * and then make the difference between * 1st and 3rd digits.

    Jorel already has a link to this (provided by me in another thread): https://en.excel-translator.de/translator/

    Here is the most complicated formula translated into Portuguese:

    =S6-Q6

    And here are the instructions in Portuguese courtesy of Mr Google:

    0) Começando com as colunas A: O
    1) Em Q6, insira = A6 e copie / cole / preencha em Q6: AE6
    2) Selecione a coluna AC e insira a coluna. Repita para a coluna Z, W, T.
    3) Na recém-criada coluna vazia T, digite = S6-Q6. Copie T6 e cole em X6, AB6, AF6, AJ6
    4) Para obter a tabela de resumo para a direita, AM6 = T6, AN6 = X6, AO6 = AB6, AP6 = AF6, AQ6 = AJ6.
    5) Selecione Q6: AQ6 e copie / cole / preencha.
    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.

  8. #8
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Lightbulb

    Hi !

    Again, as Excel is still internal in english even with any local version whatever deutch, french, german, italian, spanish …
    no need to convert any english formula as Excel can do it itself ‼

    The child level tip :
    just select the formula cell in the worksheet then on VBE side open the Immediate window (Ctrl G) then valid this :

    Activecell.Formula = "the formula here" that's it ! In case of double quote within the formula just double each one …

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

    Re: separate the 5 threes * and then make the difference between * 1st and 3rd digits.

    hello Marc L ok perfecr , conglatulaions 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. generate threes with delta 2 value and also 3 between the trio from 01 to 25.
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-15-2019, 12:10 PM
  2. [SOLVED] separate the start and end digits and high and low digits and *
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-21-2018, 11:59 AM
  3. [SOLVED] separate missing digits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-03-2018, 11:25 PM
  4. [SOLVED] Add digits to make string 10 digits
    By jscalem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2016, 05:55 PM
  5. [SOLVED] Separate Numbers into Digits^3
    By Sam9530130 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2012, 11:36 AM
  6. separate-out digits from numbers
    By stewart08 in forum Excel General
    Replies: 3
    Last Post: 01-28-2010, 10:12 AM
  7. Replies: 0
    Last Post: 10-07-2008, 10:45 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