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

[TABLE="width: 495"]
<tbody>[TR]
[TD="class: xl63, width: 33"]6[/TD]
[TD="class: xl63, width: 33"]6[/TD]
[TD="class: xl63, width: 33"]6[/TD]
[TD="class: xl63, width: 33"]6[/TD]
[TD="class: xl63, width: 33"]6[/TD]
[TD="class: xl63, width: 33"]5[/TD]
[TD="class: xl63, width: 33"]5[/TD]
[TD="class: xl63, width: 33"]5[/TD]
[TD="class: xl63, width: 33"]5[/TD]
[TD="class: xl63, width: 33"]4[/TD]
[TD="class: xl63, width: 33"]4[/TD]
[TD="class: xl63, width: 33"]4[/TD]
[TD="class: xl63, width: 33"]3[/TD]
[TD="class: xl63, width: 33"]3[/TD]
[TD="class: xl63, width: 33"]2[/TD]
[/TR]
</tbody>[/TABLE]

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

<tbody>
[TD="align: center"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]

</tbody>

Sheet3​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]B1[/TH]
[TD="align: left"]=IFERROR(IF(COUNTIF($A1:A1,A1)< A1-1,A1,IF(A1=2,"",A1-1)),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

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.