Rearranging data.

[serge]

Hi All,

I need a formula in cell AU9 to drag right and down, that will rearrange the data from AM9:AQ9 and would put the "S" first and then the "F" after, thank you.

Excel Workbook
	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ
8
9		S	F	F	S	F				S	S	F	F	F
10		F	S	S	F	F				S	S	F	F	F
11		S	S	F	S	S				S	S	S	S	F
12
Sheet

 

[Joe4]

Are "S" and "F" the only possible values?

 

[serge]

Yes, Only S and F.

 

[Joe4]

Then put this formula in AU9 and copy/drag it to all other cells:

=IF(COUNTIF($AM9:$AQ9,"S")>(COLUMN(AU9)-47),"S","F")

 

[serge]

Perfect, Thank you so much Joe4, and also for such a quick respond, I really appreciate it.
Serge.

 

[Joe4]

You are welcome.
Glad I was able to help!