Find max value from 5 non-continguous columns

[IsabelleB]

Is there a formula to find the max value from columns C,G,K,O,S and put the value into column W for the example below:
C,G,K,O,S ARE THE Term columns FIRST ROW: 1122, 1125, 1112, 111,1107 ( I CANNOT GET THE COLUMNS TO LOOK RIGHT WHEN I PASTE THE EXAMPLE)

C G K O S
Term s crs g Term s crs g Term s crs g Term s crs g Term s crs g
1122 CIT 2563 A 1125 CIT 2513 A 1112 CIT 2523 B 1115 CIT 2323 C 1107 CIT 2533 A
1145 CIT 2563 A 1137 CIT 2513 A 1147 CIT 2523 A 1137 CIT 2323 A 1147 CIT 2533 A
1145 CIT 2563 B 1147 CIT 2513 A 1155 CIT 2523 A 1145 CIT 2323 A 1152 CIT 2533 A

 

[Rick Rothstein]

Is there a formula to find the max value from columns C,G,K,O,S and put the value into column W for the example below:
C G K O S
Term s crs g Term s crs g Term s crs g Term s crs g Term s crs g
1122 CIT 2563 A 1125 CIT 2513 A 1112 CIT 2523 B 1115 CIT 2323 C 1107 CIT 2533 A
1145 CIT 2563 A 1137 CIT 2513 A 1147 CIT 2523 A 1137 CIT 2323 A 1147 CIT 2533 A
1145 CIT 2563 B 1147 CIT 2513 A 1155 CIT 2523 A 1145 CIT 2323 A 1152 CIT 2533 A

I think you want this placed in cell W2 and copied down...

=MAX(C2,G2,K2,O2,S2)

 

[IsabelleB]

I think you want this placed in cell W2 and copied down...

=MAX(C2,G2,K2,O2,S2)

thanks so much, that worked.