Question description:
This user has given permission to use the problem statement for this
blog.
I want to know how to filter out duplicate data in a column in excel
Solved by D. U. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
25/10/2017 - 03:59
hihi
Excelchat Expert
25/10/2017 - 03:59
Hi there, Thanks for choosing Got It Pro-Excel! How may I help you today?
Excelchat Expert
25/10/2017 - 04:01
let me first confirm, are you using microsoft excel or google sheets?
Excelchat Expert
25/10/2017 - 04:03
are you there?
Excelchat Expert
25/10/2017 - 04:05
?
Excelchat Expert
25/10/2017 - 04:06
I will just go ahead and explain for excel
Excelchat Expert
25/10/2017 - 04:06
Select the range of cells from where you need to remove the duplicates (either a column or a row)
Excelchat Expert
25/10/2017 - 04:07
then click on the Data tab on the ribbon
Excelchat Expert
25/10/2017 - 04:08
there you will find the remove duplicates button. click it
Excelchat Expert
25/10/2017 - 04:08
it will open up a dialog box
Excelchat Expert
25/10/2017 - 04:08
check the appropriate check box and click ok
Excelchat Expert
25/10/2017 - 04:09
Excel will automatically remove the duplicates
Excelchat Expert
25/10/2017 - 04:09
and keep only one copy
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.