Deduping data

Hi Liz,

Thank you for your question.

There is no specific way of doing this in Excel 2003. However there is a method using Autofilter that you could try.

I have included a hyperlink to a Microsoft site explaining the Autofilter method:

http://office.microsoft.com/en-us/excel/HA010346261033.aspx

There are also formulas you can try such as:

=IF(AND(B3=B4,C3=C4),"delete","don't delete")

Here is a link to some other formulas you could try:

http://www.microsoft.com/office/community/en-us/default.mspx?& ;lang=&cr=&guid=&sloc=en-us&dg=microsoft.public.excel.worksheet.functions&p=1&tid=30769C6D-0DC9-4670-BF95-BE79BC8201F7&mid=30769C6D-0DC9-4670-BF95-BE79BC8201F7

I hope this answers your question.

Regards

Simon