You can either select remove duplicate in DATA tab. or you can select
conditional formating in Home tab and then select Highlight Cell
RuleDuplicate Values.In formaer case , duplicate value will be removed
while in later case it will be highlighted only. Therefore, depending upon
requirement you
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, choose
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 rajputpanka...@gmail.comwrote:
Its cannot help me i provid you an example ; help me to find
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*
--
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
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 rajputpanka...@gmail.com wrote:
Hi,
I have a problem i have
You can use conditional formating.
Chandra Gupta Maurya
On Fri, Aug 27, 2010 at 10:42 AM, Pankaj Kumar rajputpanka...@gmail.comwrote:
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
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: