Ascending order formula.

[serge]

In row A1:J1 I have the numbers from 0 to 9 . Then below, in row 3 as example I have 7-6-2-1-18-13-3-5-55-271 which are reference to row 1.Now what I need if possible is to rearrange row 1 in an ascending order according of row 3.See the way it should be in L3:U3.

And row 4 as 2nd example.Thank you in advance for any help.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	0	1	2	3	4	5	6	7	8	9
2
3	7	6	2	1	18	13	3	5	55	271		3	2	6	7	1	0	5	4	8	9
4	33	12	1	4	11	10	3	2	9	13		2	7	6	3	8	5	4	1	9	0
5
Sheet2

 

[villy]

|If this is asc whhy it is starting at 13 instead of 1?

 

[njimack]

Formula in L3: =INDEX($A$1:$J$1,MATCH(SMALL($A3:$J3,COLUMN(A$1)),$A3:$J3,0))
(copy down and across as far as required)

 

[serge]

njimack,

Beautiful, it work perfectly the way I needed it, and you did it in a record time.

Thank you very much.

Serge.

 

[njimack]

No problem, thanks for the feedback.

 

[serge]

Villy,

It start at 3 because :

3 in row 1 is at 1 in row 3 then 2 in row 1 is at 2 in row 3 and 6 in row 1 is at 3 in row 3 etc... etc...

 

[villy]

Villy,

It start at 3 because :

3 in row 1 is at 1 in row 3 then 2 in row 1 is at 2 in row 3 and 6 in row 1 is at 3 in row 3 etc... etc...

OK sorry my bad I misunderstood the explanation.
Ok then great job by njimack...

 

[serge]

njimack,

I have a small problem, just because in my example the data are in A1:J1 and A3:J3 and the formula in L3.

My reel data are not in those cells that was just a sample, I tried to adjust the formula to my reel data and I can't make it work !!!

If you can help me ?

Here are the reel data cells :

0:9 are in : Y1 : AH1

data are in : Y6844 : AH6844

And the formula should start in cell : FV6844.

Sorry about that.

Thank you.

 

[Peter_SSs]

I would suggest a slight change to Neil's formula to make it more robust. At the moment, if you add a new column A for some reason, the results will go astray. A simple change would stop that problem.

Try changing the red bits:

L3 Neil: =INDEX($A$1:$J$1,MATCH(SMALL($A3:$J3,COLUMN(A$1)),$A3:$J3,0))
L3 Peter: =INDEX($A$1:$J$1,MATCH(SMALL($A3:$J3,COLUMNS($L3:L3)),$A3:$J3,0))

 

[Peter_SSs]

Here are the reel data cells :

0:9 are in : Y1 : AH1

data are in : Y6844 : AH6844

And the formula should start in cell : FV6844.

My formula adjusted for that:

Excel Workbook
	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	FU	FV	FW	FX	FY	FZ	GA	GB	GC	GD	GE
1	0	1	2	3	4	5	6	7	8	9
2
6843
6844	7	6	2	1	18	13	3	5	55	271				3	2	6	7	1	0	5	4	8	9
6845	33	12	1	4	11	10	3	2	9	13				2	7	6	3	8	5	4	1	9	0
Order