 |
|
|
 |
New Member
|
|
Jul 11, 2012, 05:31 AM
|
|
Duplicate Values
Hi,
How to identify the duplicate values in same sheet. Eg. A1,A2,A3,A1.
Regards,
|
|
 |
New Member
|
|
Jul 11, 2012, 05:35 AM
|
|
Hi,
How to identify the duplicate values in same sheet. Eg. A1,A2,A3,A1.
|
|
 |
Software Expert
|
|
Jul 11, 2012, 01:18 PM
|
|
You can use CONDITIONAL FORMATTING to light up cells that are duplicates.
For column A, for instance:
1) Highlight column A
2) Open the Conditional Formatting window and apply a new custom rule with this formula:
=COUNTIF(A:A, A1)>1
|
|
 |
New Member
|
|
Jul 15, 2012, 12:40 PM
|
|
The "advanced" filter option on the "Data" dropdown menu has the "unique records only". This feature will remove the duplicates from the list. Actually it "hides" the rows unless you opt to copy the data to a new location.
|
|
 |
New Member
|
|
Jul 18, 2012, 05:31 AM
|
|
Hi,
Thank you for the solution.
one more clarification if the values are duplicate in the same rows; then how to enable those duplicate valuse in next rows.
|
|
 |
Software Expert
|
|
Jul 18, 2012, 08:27 AM
|
|
Please elaborate... or attach a sample workbook demonstrating everything you're talking about. Mock it all up manually so we can see everything.
|
|
Question Tools |
Search this Question |
|
|
Add your answer here.
Check out some similar questions!
Duplicate name
[ 5 Answers ]
At startup a notice tells me I have duplicate names on my PC.Only my name is in server accounts so how do I find the 2nd one to delete,cheers
Can't duplicate hyperlink
[ 3 Answers ]
In the past, if I copied a browser address into a Works document, the address would underline in blue and was clickable to open that browser address from within the Works document. For some reason, that is no longer valid. I can't think of any changes I've made to Firefox to alter this action. How...
Duplicate IP
[ 1 Answers ]
Daer all
Good morning , I'm very pleasure to join your forum , I have problem with
My router which is connected to RADIUS server , more than one can connect with
Specific username , hence they will take same IP , I want any command in CISCO
...
View more questions
Search
|