Hi
I am using the following formula to find the earliest date in a column of cells for a particular year, in this example, 1994.
=AGGREGATE(15,6,Records!$F:$F/(YEAR(Records!$F:$F)=1994),1)
I now wish to modify this such that it will only consider cells where a corresponding cell has a value...