Which formula?

[Robert Mika]

I have column of digits and numbers

Count
1
2
3
1
3
4
1
5
1
8
7
10
9
Is there a formula to look at the "Count" header (as the will be more columns) will when copying down bring all those numbers in sequence:
1
1
1
1
2
3
3
4
5
7
8
9
10

 

[DonkeyOte]

Not entirely clear but I suspect you'll want to check out the SMALL function (incrementing k via ROWS etc...)

 

[Robert Mika]

Hi DonkeyOte,
Thanks for replay.
What else to add..?

There is column of random numbers(digits) and I would like to return them in increasing sequence...

Any tip?

 

[DonkeyOte]

You mention other columns etc and COUNT header but the context isn't very clear.

In terms of your literal example and use of SMALL etc see below:

Excel Workbook
	A	B	C
1	Count
2	1		1
3	2		1
4	3		1
5	1		1
6	3		2
7	4		3
8	1		3
9	5		4
10	1		5
11	8		7
12	7		8
13	10		9
14	9		10
Sheet3

 

[Robert Mika]

The best solution are the simplest one.
Thanks a lot.