Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
recent postings not seen | Excel Worksheet Functions | |||
Select the most recent date | Excel Worksheet Functions | |||
Recent Files | Excel Discussion (Misc queries) | |||
most recent date | Excel Discussion (Misc queries) | |||
~Recent File~ | Excel Worksheet Functions |