View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Compare multiple dates, can enumerate cell based on most recent date

Try something like this in cell I1:

=COUNTIF(I3:I100,MAX($I$3:$L$3))

then copy to cells J1, K1 and L1. This assumes you will have up to 100
items in each column - adjust to suit.

Hope this helps.

Pete