Excel - most recent date

  Stubacka 11:59 19 Jan 06
Locked

I have a worksheet with Project names across the top and House Types down the left.
The grid contains only dates of when a house type was used in a project.
Is there a way to have a column at the end of the projects that will read back along the rows and return the most recent date in the row?
Is it then possible for the cell (or cells) containing that date to be highlighted?

  stlucia 13:34 19 Jan 06

The "MAX" function will give you the maximum in a range of upto 30 specified cells, which could all be in the same row. "DMAX" also does the same for a specified range within a single column.

You could then use conditional formatting to highlight the cell who's date is equal to the maximum that's been found.

  Stubacka 13:39 19 Jan 06

Exactly what I wanted - thanks stlucia

This thread is now locked and can not be replied to.

Qualcomm Snapdragon 835 benchmarks: Antutu, Geekbench 4, GFXBench and PCMark results

1995-2015: How technology has changed the world in 20 years

This stop-frame animation tells a moving story of domestic violence for Refuge

New iPad 2017 preview: Apple's affordable but underspecced new iPad may appeal to the education…