Thanks, I will follow up
On Mon, Sep 27, 2010 at 7:11 AM, P.VIJAYKUMAR wrote:
> Hello,
>
> There are Excel addins for removing Duplicates.You can Download and Install
> them from www.office-excel.com,www.ablebits.com ... etc.There is also an
> addin called "Ultimate addin" for Excel which conta
Hello,
There are Excel addins for removing Duplicates.You can Download and Install
them from www.office-excel.com,www.ablebits.com ... etc.There is also an
addin called "Ultimate addin" for Excel which contains a lot of features
along with duplicate remover.
Regards,
VIJAY KUMAR
--
Thanks for your advice
On Thu, Sep 23, 2010 at 3:18 PM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> if you want to refer more than one column for identifying duplication you
> need to concatenate the columns for advance filter... please keep in
> mind.
>
> Thanks
> Srini
if you want to refer more than one column for identifying duplication you
need to concatenate the columns for advance filter... please keep in
mind.
Thanks
Srinivasan E
On Thu, Sep 23, 2010 at 4:11 PM, janet dickson wrote:
> Thanks for your response I used *Advanced filter *and it worked out
Thanks for your response I used *Advanced filter *and it worked out.
One Love...
On Thu, Sep 23, 2010 at 12:28 PM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:
> Step1: Use additional columns as Test1 & test 2 in Column H & I
> Step2: Add the Below formula to H2
> =A
Step1: Use additional columns as Test1 & test 2 in Column H & I
Step2: Add the Below formula to H2
=A2&C2&D2
Step3: Add the Below formula to I2
=COUNTIF(H$2:H2,H2)
Step4: Select H2 & I2 then Copy paste the formula to the below cells in
column H&I
Step5: Select the first row that th
Hi,
See the attached file for details.
Chandru
On Thu, Sep 23, 2010 at 2:07 PM, janet dickson wrote:
> Hi All,
>
> Team, see attached file, please help me on how to remove duplicates in .xls
> file.
>
> .on love
>
>
>
--
You can use Advance filters to remove the duplicates. Select the data...Go
to Data - Filter - Advance Filter - Click on Unique Records only - and Click
Ok...All the duplicate records will be filtered of.
Thanks,
Shreedar
On Thu, Sep 23, 2010 at 2:07 PM, janet dickson wrote:
> Hi All,
>
> Team, s
Hi All,
Team, see attached file, please help me on how to remove duplicates in .xls
file.
.on love
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.
