Reply by be09.
1/ Method 1 (will take 5 minutes): To find the duplicate numbers:
In D3 you use the formula:
=IF(COUNTIF(C3:C37772,C3)1,Duplicate, )
Select cell D3 and Fill down to the final data. Duplication of any
cell will display text Duplicate, you used Autofillter select
Duplicate and
Narayanappa manjunath.narayana...@aon.co.uk
Subject: $$Excel-Macros$$ REmove duplicate entries
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Date: Thursday, November 22, 2012, 7:48 PM
Dear Team,
In the above attached Spreadsheet, I have more than 3777 row in which
Thank you so much
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ravinder negi
Sent: 23 November 2012 06:46
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ REmove duplicate entries
You can use trim function of excel like =trim(cell