Hi All,
Have 2 sheets of athletics records from 2 years and want to get best of both into 1 for the school records.
Ok with the results using the "small function":
=SMALL(Sheet1:Sheet2!L2:L5,1)
But need to bring across the name associated with this value and can't figure out how.
Love some help.
Kind regards
Bookmarks