Name List Formula Help
Gary,
Thanks for the response, what you suggested works but is there anyway I can
remove the blank rows in-between the returned cells from sheet 1 in sheet 2.
Thanks,
john
"Gary''s Student" wrote:
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
|