Repeating numbers in reducing pattern

hyosunko

New Member
Joined
Aug 14, 2018
Messages
2
I am trying to generate repeating numbers in the cell by decreasing patterns

Here's the pattern: if starting number is 6

666665555444332

<tbody>
</tbody>

Thank you for help in advance.
 

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,159
Welcome to the MrExcel forum.

Try:

ABCDEFGHIJKLMNOP
1666665555444332

<tbody>
</tbody>
Sheet3

Worksheet Formulas
CellFormula
B1=IFERROR(IF(COUNTIF($A1:A1,A1)< A1-1,A1,IF(A1=2,"",A1-1)),"")

<tbody>
</tbody>

<tbody>
</tbody>

Put the number you want in A1, put the formula in B1 and drag it right as needed.
 
Last edited:

Forum statistics

Threads
1,085,542
Messages
5,384,330
Members
401,887
Latest member
Somesh

Some videos you may like

This Week's Hot Topics

Top