[shan]

I'm stuck. I could easily do this in php&mysql, but i can't, i have to do it in excell. what i've got is a very simple workbook with 13 months of data.......all that's in this is 1 coloum with about 3000-5000 records. only 15-16 digit numbers.....i've put them in order and have wrote a quick if statment in the next coloum saying that if this record, say A2=A1 then print DUPLICATE, if not print good. That works well, now what i want to do is completely delete each row that b5(or whatever row) says duplicate. anyone know a quick easy way about this?

Thanks,
Shan....


i know this isn't in MS Office section but, noone goes there, that's why it's here....hahaha

[nak-1]

Copy the column, paste it into microsoft access as a table, design a select query on the table, include the 1 field, click the 'group by' button, switch to datasheet view, copy the contents, paste back to excel.

Et voila, 1 de-duped list of numbers.

If you have to stay in excel you will find it a lot harder....

[shan]

well, that'd work but i just took a different route. i used the advanced filter feature and selected unique records only....