Koen Verbeeck (10/3/2013)
J39L4753 (10/3/2013)
Sorry forgot to add that A8, A9 E8, E9, L8 are cell rows within ExcelColumn A = PersonID
Column E = DateOfAppt
Column L = is the column that I will use to return the answer within the formula.
I realized that, but I was not going to guess column names.
I'm confident you can put the column names yourself in the query.
But the bit I'm struggling with is that like with A9=A8, this is comparing PersonID with the row above etc