Compile a macro to locate unique data (eg. 9999) in a column, sort it and
then instruct Excel to delete data to the right of anything that says 9999.
--
Steve