How can we find duplicate values in MS excel sheet?

Asked by Last Modified  

1 Answer

Follow 1
Answer

Please enter your answer

Advanced Excel & PowerPoint Trainer

There are various ways to identify duplicate or right treatment of the Duplicates:1 To Highlight Duplicates: home---- conditional formatting--- highlight cell rules---highlight duplicates.2. to remove duplicates: Data--- Remove Duplicates.3. To Hide DUplicates: Data---- Advanced--- Advance Filter---CHeck...
read more
There are various ways to identify duplicate or right treatment of the Duplicates:1 To Highlight Duplicates: home---- conditional formatting--- highlight cell rules---highlight duplicates.2. to remove duplicates: Data--- Remove Duplicates.3. To Hide DUplicates: Data---- Advanced--- Advance Filter---CHeck Unique records Only.4. To Find the Unique Values: You may use UNIQUE Function prived your Excel version should have that function. read less
Comments

Related Questions

What is exact number of days required to learn basic & advanced excel?
10-15 days sufficient but you need practice on that.
Profile Photo
Anusha
What is the major concepts Excel VBA Training teaches?
- Macro programming - The Basics of vba - Variables,constants - Data types - User defined types - Working with operators - Reserved words - Control flow statements (if if else multiple else if select...
Profile Photo
Jayant
How to write square in excel?
Format > Cells > Font > check Superscript then type '2' which will appear as superscript Format > Cells > Font > uncheck Superscript
Profile Photo
Dharmendra
0 0
View Comments9
What is use of VBA? Can you explain it?
Hi Venkat, As per my opinion and experience, we are using VBA for reducing the repetitive task in excel. For example: Suppose every day you are preparing an attendance tracker in which you will mark present/absent...
Profile Photo
Venkat
0 0
View Comments5

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

What is a VBA Module?
VBA code is stored and typed in the VBA Editor in what are called modules As stated on the VBA Editor page, a collection of modules is what is called a VBA project Every major Microsoft Office product...
Profile Photo

Idioms and meanings - Lesson 2 of 11
Idioms Beginning with C and D (Choose the answer that best fits the meaning) Idioms Beginning with C Idioms Beginning with D To "call it a day" means ___.a. to quitb. it becomes eveningc....
Profile Photo

Chart
A chart is a set of coordinates When you make a chart you start with an empty, two-dimensional space, a vertical dimension (y) and a horizontal dimension (x) . You also have a data source. Your job is...
Profile Photo


VBA Function - RIGHT
RIGHT function in VBA returns the Specified number of characters from the end of a text string Syntax: Right(String,Length) Sub RIGHT_1() Dim mystring As String mystring = "Narendra Modi" MsgBox Right(mystring,...
Profile Photo

Recommended Articles

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Whether it was the Internet Era of 90s or the Big Data Era of today, Information Technology (IT) has given birth to several lucrative career options for many. Though there will not be a “significant" increase in demand for IT professionals in 2014 as compared to 2013, a “steady” demand for IT professionals is rest assured...

Read full article >

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you