Sequencia trocada ate certo numero

[nelson288]

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

[JeteMc]

[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:

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.

[nelson288]

Desculpe-me o anexo achei como colocar??

[JeteMc]

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.

[nelson288]

Ok ...tudo certo, obrigado!!

[JeteMc]

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