how do i select the most recent value in a row

[Guest]

I have dept survey results data in 12 columns (Jan - Jun). I am trying to
pull the most recent results for each dept (could be in any of the months)
into another column. I am stumped as to what formula would be? Can anyone
offer assistance?
I am using Excel 2003.

 

[Don Guillett]

It would be helpful if you posted a sample layout

 

[Guest]

Sample of data is:
Depts Jan Feb Mar Apr
6100 67 59
6105 98 93
8150 76

would like to pull in most recent survey results (in month columns) into
separate column

 

[Don Guillett]

One way would be to insert a column to the LEFT of your data and using a
formula to match any number larger than possible in your data
=INDEX(2:2,0,MATCH(99999,2:2))
or a macro
Sub lastcol()
For i = 2 To Cells(Rows.Count, "a").End(xlUp).Row
x = Cells(i, Columns.Count).End(xlToLeft)
MsgBox x
Next i
End Sub