Hi I have a problem with a table I have created.

I have a list of customers in Column B, & The Date they became a customer in COlumn A.

From Column D to BK, I have purchase dates.

In the corresponding cells I have a 1/0 dependant on whether a purchase was made on that date.

In BL I Have the number of Purchases made.

In BM I want the date that the first purchase was made....

E.g.
...Signup...Name.........27/7/06....28/7/06....29/7/06....Purchases..1st Time
1 27/7/06-John Smith-.....0.............1...........0..............1............28/7/06


Getting the first purchase date to be returned is my problem.

Ty.