In Sheet2, enter:

=IF(Sheet1!B2=0,Sheet1!A2,"") and copy down
--
Gary''s Student - gsnu200855


"John" wrote:

I have a list of names in cells A2:A30 and in cells B2:B30 I need to enter £
for example money paid each week. I need on a seperate worksheet (sheet2) a
list of names of those who have not paid or where cells B2:B30 are blank..! I
am using Excel 2003 sp3.

Any help would be very much appreciated.

Thanks,

John