How to reference cell based on MAX date and another condition?
I am trying to reference another sheet that has multiple data for the same building:
On another sheet I am trying to pass over the information from Column4 if Column3 equals "Cobb Stadium" and by picked the MAX Created Date & Time.
So it would pass "Yes" Since the last row has the Max date and time from today.
Anyone have any ideas?
Help Article Resources
Check out the Formula Handbook template!