Dear Rajput,
It depends if you want to just see the duplicate records OR you want to do
some calculation / analysis on them, accordingly you need to choose the
answers. Conditional formatting will highlight the cells and Advance filter
can extract the unique set of data and so on..!!
--
Thanks
Hi Pankaj,
Go to advanced filters and select Unique records
Regards
Umesh
On Fri, Aug 27, 2010 at 11:21 AM, rajput wrote:
> I have a lot of Data including number & Alphabet , I am confussed
> that duplicate will be entered,,,which command i find duplicate records
>
> --
>
> -
Please attach the example file
Chandra Gupta Maurya
On Fri, Aug 27, 2010 at 11:21 AM, rajput wrote:
> I have a lot of Data including number & Alphabet , I am confussed
> that duplicate will be entered,,,which command i find duplicate records
>
> --
>
> --
I have a lot of Data including number & Alphabet , I am confussed
that duplicate will be entered,,,which command i find duplicate records
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips t
