Excel Forum



Excel Magic Trick 547: Calculating Last Time File Was Accessed From Server Computer


See how to analyze data dump from server computer to see when each file was last accessed using COUNTIF, MAX and IF functions and an array formula.





Got a Question? Ask it Here in the Forum.