how do i select the most recent value in a row

D

Darla

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.
 
D

Darla

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
 
D

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
 
Top