I have 10 rows, say A1 to A10, all have dates in them.
I'd like to identify in which row the oldest date is.
I know I need to link =ROW and =MIN(A1:A10) into one single formula but not sure how.
Also, would the formula work if there are any blank cells between A1 and A10?
Thanks.