If you change the layout of your spreadsheet so that only two columns
contain the data, where Column A contains the date, and Column B
contains the corresponding values, you could use the following formula
instead...

=IF(N(H2),INDEX(A2:A21,MATCH(TRUE,SUBTOTAL(9,OFFSE T(B2:B21,,,ROW(B2:B21)-
ROW(B2)+1))=H2,0)),"")

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
Steven Cheng wrote:

Thanks Domenic....looks like a complicated formula....maybe I should have
just created a function for this instead...