Hi All,

I have a large table of data that contains the following information:-

Column 1 - File Name
Column 2 - Version Number
Column 3 - Date

Essentially it is a list of what documents were saved when and what
version number they were.

What formula could I use to find the maximum version number that is
between 2 specified dates.

I.e. the highest version of document1.doc that was saved between 1/1/04
and 1/2/04.

Any ideas?

Thanks

Andi


--
andibevan
------------------------------------------------------------------------
andibevan's Profile: http://www.excelforum.com/member.php...fo&userid=9882
View this thread: http://www.excelforum.com/showthread...hreadid=273131