**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.*