View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marge Marge is offline
external usenet poster
 
Posts: 33
Default find most recent date in a row

I have columns similar to these (the dates represent project completion dates):

A B C
blue team OK red team OK white team OK
4/5/09 5/7/09 6/27/09

In column D I want to enter the most recent of the A, B and C dates. If the
dates were in columns instead of rows I could filter for the most
recent....how can I "filter" across a row?

Thanks for any help you can offer!