"macca" wrote
.. I want it to compare the week 2 number
column (Column C) to the names (column A)
and then copy the name into a seperate list
but it seems unable to skip the row inbetween ..

Harzarding one guess ..

Assume data is in row2 down,
(Names in col A, numbers in col C as above)

Using 2 empty cols to the right, say cols E & F

Put in E2:
=IF(ISERROR(SMALL(F:F,ROWS($A$1:A1))),"",
INDEX(A:A,MATCH(SMALL(F:F,ROWS($A$1:A1)),F:F,0)))

Put in F2:
=IF(C2="","",IF(C25,C2+ROW()/10^10,""))
(Leave F1 empty)

Select E2:F2, copy down until the last row of data in cols A & C

Col E will return the list of names from col A
with numbers 5 in col C, all neatly bunched at the top ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--