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
|