KETO42
join:2007-06-14
Absecon, NJ
| [Excel] Indicate "Latest Revision"
This is probably pretty simple, but I cannot figure it out.
I have a spread sheet that lists drawings and specifications, revision dates and other info related to them. Not all drawings/specs are revised on the same date, and are revised several times. Each revision date is in its own column. What is the best way to show, in a single column, the latest revision date and not have the world's longest "IF" statement?
Example:
No. Description Revision Dates
A-100 1st Floor Plan 01/10/08 02/02/08 02/15/08
A-101 2nd Floor Plan 01/10/08 02/02/08
A-102 3rd Floor Plan 01/10/08 02/12/08
Thanks in advance.
-K |
