Repeating numbers in reducing pattern

[hyosunko]

I am trying to generate repeating numbers in the cell by decreasing patterns

Here's the pattern: if starting number is 6

6

6

6

6

6

5

5

5

5

4

4

4

3

3

2

<tbody>
</tbody>

Thank you for help in advance.

 

[Eric W]

Welcome to the MrExcel forum.

Try:

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	6	6	6	6	6	5	5	5	5	4	4	4	3	3	2

<tbody>
</tbody>

Sheet3​

Worksheet Formulas Cell Formula 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.

 

[hyosunko]

I didn't think about that.
Thanks Eric.