Hi.

I have a table of data which looks as follows:

Name 1/5/07 8/5/07 15/5/07 22/5/07 0/0/00
a1 £50 £50 £50 £0 £0
a2 £0 £50 £50 £50 £0
a3 £0 £0 £50 £50 £0
a4 £50 £0 £0 £0 £0

I want to be able to look up the earliest and latest date that each
individual was active (i.e. £ 0), so for a1 I would want earliest date to
be 1/5/07 and latest date to be 15/5/07.

Is there an easy way to do this?

Thanks in advance

Craig