Thread: How to find the most recent date in a column based on other column
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Veretax Veretax is offline
external usenet poster
  
Posts: 5
Default How to find the most recent date in a column based on other co


"Bob Phillips" wrote:

Why don't you just use the original formula, and C F on a value of 0 with a
red font and red background?

--
HTH

Bob Phillips


yeah you could in theory do that, but I like it saying Never instead of 0...
or even blank could be used in this case. I decided to use Never.
Reply With QuoteReply With Quote