+ Reply to Thread
Results 1 to 6 of 6

Sequencia trocada ate certo numero

  1. #1
    Registered User
    Join Date
    06-02-2021
    Location
    são paulo
    MS-Off Ver
    365
    Posts
    4

    Sequencia trocada ate certo numero

    Ola, colegas estou com um problema: Na planilha tenho 1 a 15 - sendo a contagem antes e depois - o problema e quando chega em 15 - teria que fica 14-15-1 e não 14-15-16 e também NÃO O-1-2 e sim 1-2-3 ..coloquei uma plan em anexo p entenderem melhor.. obrigado pela atenção...

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,257

    Re: Sequencia trocada ate certo numero

    [quote]coloquei uma plan em anexo p entenderem melhor[/qutoe]
    Translated this reads: "‎i put a plan attached p understand better‎"
    Which would imply that there should be an attachment and is not.
    Instructions for attaching an Excel file are given in the banner at the top of the page.
    From my understanding of the description in post #1, you may be looking to use the MOD function as in the following pasted into cell A1 and copied down to cell A16:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Note that I believe your system will use the semicolon to separate the number and divisor arguments, if not replace with a comma.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    06-02-2021
    Location
    são paulo
    MS-Off Ver
    365
    Posts
    4

    Re: Sequencia trocada ate certo numero

    Desculpe-me o anexo achei como colocar??
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,257

    Re: Sequencia trocada ate certo numero

    Try the following:
    I4: =MOD(J4-1,15)
    J4: =IF(F3=1,2,F3)
    K4: =MOD(J4+1,15)
    Let us know if you have any questions.

  5. #5
    Registered User
    Join Date
    06-02-2021
    Location
    são paulo
    MS-Off Ver
    365
    Posts
    4

    Thumbs up Re: Sequencia trocada ate certo numero

    Ok ...tudo certo, obrigado!!

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    12,257

    Re: Sequencia trocada ate certo numero

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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. Bucar numero de serie en Mac
    By Suerc in forum Non English Excel
    Replies: 0
    Last Post: 02-24-2021, 05:58 AM
  2. Bucar numero de serie en Mac
    By Suerc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2021, 05:58 AM
  3. Localizar numero entre duas colunas
    By dugsblack in forum Non English Excel
    Replies: 5
    Last Post: 02-26-2019, 03:33 PM
  4. Localizar numero entre duas colunas
    By dugsblack in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-26-2019, 12:41 PM
  5. Cambiar el Formato de la Celda de Fecha a Número
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-28-2005, 06:54 AM
  6. celda con numero IP
    By Gilberto in forum Excel General
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM
  7. [SOLVED] Cambiar de numero a letra.
    By japerezestebaran in forum Excel General
    Replies: 1
    Last Post: 10-31-2005, 06:05 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