I'm not sure if it can be easily done but I have a column 20000 or so rows long and have been asked to tidy it up. I have repeated data throughout the column and so (when i sort it) may have, say: 5 rows of xxxx, 16 rows of yyyy and then 1 row of zzzz, etc... I need to know how to quickly delete the repeated entries leaving just the first cell of a series of identical entries. Maybe a macro, or some lind of function... Please help. I can't go through it manually, it'll take a week!!!