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.