Dear Pankaj
Please select the range where your data is. Then PRESS ALT,H,L,H,D. Now you
can highlight duplicate values any color.
Chandra Gupta Maurya
On Fri, Aug 27, 2010 at 11:04 AM, Pankaj Kumar wrote:
>
> Its cannot help me i provid you an example ; help me to find duplicate
>> records
>
Hi
Formula: = IF(COUNTIF(A$2:A$39,A2)>1,"Duplicated","")
And if u want to delete duplicates u can use remove duplicate from data from
menu ribbon in excel 2007
1. Copy your range of data to a blank section of the worksheet
2. Select a cell in your data set.
3. From the Data ribbon, choos
You can either select remove duplicate in DATA tab. or you can select
conditional formating in Home tab and then select Highlight Cell
Rule>Duplicate Values.In formaer case , duplicate value will be removed
while in later case it will be highlighted only. Therefore, depending upon
requirement you m
> Its cannot help me i provid you an example ; help me to find duplicate
> records
678 567 890 678 456 456 789 678 567 890 678 678 567 890 678 456 456 789
678 567 890 678 678 567 890 678 456 456 789 678 567 890 678
--
*Warm Regards
Pankaj kumar
M: 9899816107
e-mail: rajputpanka...@gmai
You can use conditional formating.
Chandra Gupta Maurya
On Fri, Aug 27, 2010 at 10:42 AM, Pankaj Kumar wrote:
> Hi,
>
> I have a problem i have a lot of data & i wanted to find duplicate record
> is there any fourmula or command in excel.
>
> --
> *Warm Regards
> Pankaj kumar
> M: 9899816107
>
if data is a value(no.) then u cn use countif function which gives u
no.of duplicate value as output
Ex:
AB
789=countif(A1)=2
789=countif(A2)=2
check this if useful.
On Fri, Aug 27, 2010 at 10:42 AM, Pankaj Kumar wrote:
> Hi,
>
> I have a problem i have a lot of data & i want
Hi Pankaj,
You can use conditional formatting to identify Duplicate Values in Excel
2007.
1) Go To --> Conditional Formatting
2) Highlight Cells Rules
3) Duplicate Values
Hope it helps.
Regards,
Ayush Jain
Group Manager
On Fri, Aug 27, 2010 at 10:42 AM, Pankaj Kumar wrote:
> Hi,
>
> I have a
Hi,
I have a problem i have a lot of data & i wanted to find duplicate record is
there any fourmula or command in excel.
--
*Warm Regards
Pankaj kumar
M: 9899816107
e-mail: rajputpanka...@gmail.com
rajputpank...@yahoo.in*
--
-