I have a little problem.

Cells A1 - A10 contain student names.
Cells B1 - B10 say either 'absent' or 'present'.

I need to send letters to the students who were absent.

Therefore I would like those students who were absent to be extracted
from the names in A1 - A10 and put in another table array somewhere on
the sheet i.e. if Column B value is 'absent' then append the value in
column A.

Can this be done? Or have I not explained myself properly?




--
miss_q
------------------------------------------------------------------------
miss_q's Profile: http://www.excelforum.com/member.php...o&userid=27573
View this thread: http://www.excelforum.com/showthread...hreadid=492479