How to: Compare multiple dates and enumerate cell in row with most recent date

  • Thread starter Thread starter Tred
  • Start date Start date
T

Tred

Howdy All,

This is what I want to do:

I have a spreadsheet with 4 dates in columns I, J, K, and L starting in row
3.

In the corresponding columns of row 1, i want to count the number of times
each column contains the most recent date.

Example:

I3 = 1/1/2000, J3 = 2/2/2001, K3 = 3/3/2002, L3 = 4/4/2003

L3 would now equal 1.

Then next time column L contains the most recent date, L3 would enumerate
and equal 2, etc.

Any ideas?

Thanks,
Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top