Rearrange data.

[serge]

I'm looking for a formula that will rearrange the row from EM6:ER6 in this order, the 21511 first 11521 second, 12511 third and 11611 last.
Like the chart in ET6:EY6 and down.
Thank you.
Serge

 

[DanteAmor]

How about:

Book1
	EM	EN	EO	EP	EQ	ER	ES	ET	EU	EV	EW	EX	EY
1								21511	11521	12511	11611
2
3
4
5
6	11611	21511	11611	12511	11611	11521		21511	11521	12511	11611	11611	11611
7	11611	11521	11521	11611	11611	12511		11521	11521	12511	11611	11611	11611
8	11611	12511	12511	12511	11611	11611		12511	12511	12511	11611	11611	11611
9	11611	11521	12511	11521	12511	12511		11521	11521	12511	12511	12511	11611
sheet

Cell Formulas
Range	Formula
ET6:EY9	ET6	=IF(COUNTIF($EM6:$ER6,$ET$1)-COUNTIF($ES6:ES6,$ET$1)>0,$ET$1, IF(COUNTIF($EM6:$ER6,$EU$1)-COUNTIF($ES6:ES6,$EU$1)>0,$EU$1, IF(COUNTIF($EM6:$ER6,$EV$1)-COUNTIF($ES6:ES6,$EV$1)>0,$EV$1, IF(COUNTIF($EM6:$ER6,$EW$1)-COUNTIF($ES6:ES6,$EW$1)>0,$EW$1))))

 

[serge]

Very nice, it works perfect, Thank you very much DanteAmor, really appreciate it.
Serge.

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.