Find a row with the oldest date

  • 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.

  • MATCH returns the position of the match, so since your data starts in row 1,

    =MATCH(MIN(A1:A10),A1:A10,0)

    will return the row number.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why