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.