Question description:
This user has given permission to use the problem statement for this
blog.
How do I remove the duplicates from this column but leave the number at least once?
Solved by D. D. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
04/05/2018 - 12:01
Hi KT
Excelchat Expert
04/05/2018 - 12:02
HI
Excelchat Expert
04/05/2018 - 12:02
Welcome to Got it Pro
Excelchat Expert
04/05/2018 - 12:03
For removing the duplicates you can select this column
Excelchat Expert
04/05/2018 - 12:03
Then click on data tab on the excel in your PC
Excelchat Expert
04/05/2018 - 12:03
then click on remove duplicates
Excelchat Expert
04/05/2018 - 12:04
Are you there?
Excelchat Expert
04/05/2018 - 12:04
Just follow these simple steps and you will be able to remove duplicates
Excelchat Expert
04/05/2018 - 12:04
Are you there?
User
04/05/2018 - 12:05
but that will mean \i have to individually go through over 700 items
Excelchat Expert
04/05/2018 - 12:05
No
Excelchat Expert
04/05/2018 - 12:05
You can click on top of column where it is written A
Excelchat Expert
04/05/2018 - 12:05
Do this on excel in your PC
Excelchat Expert
04/05/2018 - 12:05
Then click on data tab
Excelchat Expert
04/05/2018 - 12:06
and just select remove duplicates and proceed forward
User
04/05/2018 - 12:06
I have done that and the duplicates are highlighted but I hav to go through each one
Excelchat Expert
04/05/2018 - 12:06
Just try
User
04/05/2018 - 12:06
ok
Excelchat Expert
04/05/2018 - 12:06
Not highlighting, we are removing the duplicates
Excelchat Expert
04/05/2018 - 12:06
So every unique row is only once
Excelchat Expert
04/05/2018 - 12:08
Do you get it?
User
04/05/2018 - 12:08
Thnk you . yes. \i was doing the highlight duplicates in home, conditional format\
Excelchat Expert
04/05/2018 - 12:08
Ohk
Excelchat Expert
04/05/2018 - 12:09
Let me know if this session helped you?
User
04/05/2018 - 12:09
I had to go to the data and get remove duplictesa
Excelchat Expert
04/05/2018 - 12:09
Yes
User
04/05/2018 - 12:09
Yes
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.