Thanks for the assistance. I will tweak this to the names on the actual
sheet and make it work... Such a time saver!!
THANKS!

"Max" wrote:

Apologies, another correction

Lines
Put in B1:
=IF(ROW()COUNT($A:$A),"",INDEX(Sheet1!A:A,SMALL($ A:$A,ROW())))

should read

Put in B1:
=IF(ROW()COUNT($A:$A),"",INDEX(Master!A:A,SMALL($ A:$A,ROW())))

(I changed the source sheetname from "Sheet1" to "Master"
halfway through in testing here)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---