Hi, TABLE and Structured Reference come into play in your case.
1. Insert "Table" in the range of your dataset and name it "DS" for simplicity; what's more, u can expand the records as much as u want, whether vertically or horizontally.
2. Again I use a name "GRID" for simplicity of formula constructing; in fact, it's an unsorted array of average meeting time;
Formula:
=SUBTOTAL(1,OFFSET(DS[[#Headers],[Client]],ROW(DS)-ROW(DS[#Headers]),,,COLUMNS(DS)))+ROW(DS)%%
3. Formulae for matches based on average meeting time are constructed in the colored range.
Bookmarks