how do i select the most recent value in a row
 

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.

how do i select the most recent value in a row
 

It would be helpful if you posted a sample layout

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Darla" wrote in message
...
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.

how do i select the most recent value in a row
 

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" wrote:

It would be helpful if you posted a sample layout

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Darla" wrote in message
...
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.

how do i select the most recent value in a row
 

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



--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Darla" wrote in message
...
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" wrote:

It would be helpful if you posted a sample layout

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Darla" wrote in message
...
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.