Remember Me?

#1
October 28th 04, 11:30 AM
 andibevan Posts: n/a
Lookup Function

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

#2
October 28th 04, 12:25 PM
 Frank Kabel Posts: n/a

Hi
try thwe following array formula(entered with cTRL+SHIFT+ENTER):
=MAX(IF((A1:A100="document1.doc")*(C1:C100=DATE(2 004,1,1))*(C1:C100<DATE(2004,2,1)),B1:B100))

"andibevan" wrote:

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Jamesy Excel Discussion (Misc queries) 1 January 10th 05 03:39 PM Jamesy Excel Discussion (Misc queries) 3 January 10th 05 03:03 PM Christopher Anderson Excel Discussion (Misc queries) 3 January 5th 05 03:38 PM PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM Josef.angel Excel Worksheet Functions 1 October 29th 04 09:50 AM

All times are GMT +1. The time now is 06:25 AM.