Excel - most recent date

  Stubacka 11:59 19 Jan 06

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.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

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

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…