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
You can use trim function of excel like =trim(cell reference), and it will
remove space from the cell value and then use function remove duplicate which
is available in data->remove Duplicates.
--- On Thu, 11/22/12, Manjunath Narayanappa
wrote:
From: Manjunath Narayanappa
Subject: $$Excel-Ma
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
