Sumproduct / Max array formula problem
Hi All,
I have a spreadsheet with 3 named ranges:-
File_Name (name of file)
Version (file version)
Date_Val (date when version was saved).
For a given file (Test File1.txt) how do I return the version number of the
most recently saved document?
Thanks in advance
Andi
|