Excel - IF Function Problem - Expert Solution

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
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
Excelchat Expert 16/08/2018 - 05:30
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
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
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.