View Single Post
  #1   Report Post  
Andibevan
 
Posts: n/a
Default 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