how do i select the most recent value in a row

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
Back
Top