From Samad Asghary@21:1/5 to All on Fri Sep 11 02:55:24 2020
Hi, I'm trying to find the latest date for a single event which may used in multiple sheets in a google spread sheet.
I'm using Max and Vlookup function with sorting the data but since the event has not been registered in all sheets, some Vlookups return #N/A error and Max function can not find the maximum or latest date and return #N/A instead.
It would be greatly appreciated if any one can help me to find a way to ignore #N/A errors for finding the maximum.