Question description:
This user has given permission to use the problem statement for this
blog.
One column has a 16 digit ID number. I need to be able to copy and paste that number into a cell and it will be able to tell me if it is duplicated. If it is duplicated the number of times it has been duplicated would have to appear underneath
Solved by V. F. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
16/08/2018 - 05:04
are you there?
Excelchat Expert
16/08/2018 - 05:04
Yes
Excelchat Expert
16/08/2018 - 05:04
Hello
Excelchat Expert
16/08/2018 - 05:04
Welcome to Got It Expert.
User
16/08/2018 - 05:04
can you solve my problem?
Excelchat Expert
16/08/2018 - 05:04
Yes.
User
16/08/2018 - 05:04
One column has a 16 digit ID number. I need to be able to copy and paste that number into a cell and it will be able to tell me if it is duplicated. If it is duplicated the number of times it has been duplicated would have to appear underneath
Excelchat Expert
16/08/2018 - 05:04
Do you have an example column?
Excelchat Expert
16/08/2018 - 05:05
Or can I create one?
User
16/08/2018 - 05:05
[Uploaded an Excel file]
User
16/08/2018 - 05:05
i have attached one
User
16/08/2018 - 05:06
have you gotten ?
Excelchat Expert
16/08/2018 - 05:06
Yes.
User
16/08/2018 - 05:06
is that possible?
Excelchat Expert
16/08/2018 - 05:06
I am working on it. Hold on a second.
User
16/08/2018 - 05:06
sure
User
16/08/2018 - 05:09
Dear?
Excelchat Expert
16/08/2018 - 05:10
I may need few more minutes.
Excelchat Expert
16/08/2018 - 05:10
Sorry for waiting.
User
16/08/2018 - 05:11
only 12 mintues are remaining
User
16/08/2018 - 05:19
are you there?
Excelchat Expert
16/08/2018 - 05:19
Yes
Excelchat Expert
16/08/2018 - 05:20
I am still trying to solve the 16 digits problem.
Excelchat Expert
16/08/2018 - 05:20
If it is 15, it would be very easy.
User
16/08/2018 - 05:21
nah it will be 16
Excelchat Expert
16/08/2018 - 05:21
OK
Excelchat Expert
16/08/2018 - 05:21
I think I got it
User
16/08/2018 - 05:22
ahhhh!
Excelchat Expert
16/08/2018 - 05:24
Can I use a helper column?
User
16/08/2018 - 05:25
yes you can
User
16/08/2018 - 05:29
have you done?
Excelchat Expert
16/08/2018 - 05:30
Thank you for your patient
Excelchat Expert
16/08/2018 - 05:30
My browser was dead.
User
16/08/2018 - 05:30
would you like to tell me how have you done bcz i wanna increase my knowledge
Excelchat Expert
16/08/2018 - 05:32
You can check the spreadsheet on the left
Excelchat Expert
16/08/2018 - 05:34
I think I don't need the helper column now
Excelchat Expert
16/08/2018 - 05:35
Do you need me to explain?
Excelchat Expert
16/08/2018 - 05:35
I can explain to you.
User
16/08/2018 - 05:35
yes please!
Excelchat Expert
16/08/2018 - 05:36
COUNTIF(A:A,$D$1)
Excelchat Expert
16/08/2018 - 05:36
I just use this formula to count how many times D1 value appears in column A
Excelchat Expert
16/08/2018 - 05:37
A:A means column A
User
16/08/2018 - 05:37
got it
User
16/08/2018 - 05:37
thanks for your time :)
Excelchat Expert
16/08/2018 - 05:37
My excel doesn't work for 16 digits, which waste most of the time.
Excelchat Expert
16/08/2018 - 05:38
Sorry for that.
User
16/08/2018 - 05:38
now how can i give you my feedback?
User
16/08/2018 - 05:39
it was very good to work with you!
Excelchat Expert
16/08/2018 - 05:39
just end the session and you will see the rating page
Excelchat Expert
16/08/2018 - 05:39
Thank you.
Excelchat Expert
16/08/2018 - 05:39
Have a good one.
User
16/08/2018 - 05:39
is it free of cost
Excelchat Expert
16/08/2018 - 05:39
Yes~
User
16/08/2018 - 05:39
can you give me excel file
User
16/08/2018 - 05:40
it will be pleasure for me
User
16/08/2018 - 05:40
further every time i have new expert or same?
Excelchat Expert
16/08/2018 - 05:40
You can download it from google spreadsheet
Excelchat Expert
16/08/2018 - 05:41
New expert every time
User
16/08/2018 - 05:41
nice to work with you buddy :)
User
16/08/2018 - 05:42
for ending session should i click on back button?
Excelchat Expert
16/08/2018 - 05:43
No
Excelchat Expert
16/08/2018 - 05:43
Just click Done button.
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.
