"Scott" wrote:
I put the formulas in the cells
but all I got was an error message that
says: error found, to accept change click yes.
Do I have to click: Ctrl+Shift+Enter
when I put the first cell in and then add to the column?

No, just normal ENTER will do, they're non-array formulas

I'm not sure why you got the error, but ..
here's a sample construct to illustrate:
http://cjoint.com/?dCsjIYbE2u
Remove duplicates in column.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---