# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have values in a column sometimes 1 and sometimes more, how can i have in the next column a number of how many times found but in a row? Example: 11255 = 1 11255 = 2 11368 = 1 11368 = 2 11368 = 3 16544 = 1 99566 = 1 99566 = 2
Solved by M. Q. in 10 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 10/11/2017 - 03:09
Hello
Excelchat Expert 10/11/2017 - 03:09
Could you please explain in details
Excelchat Expert 10/11/2017 - 03:10
Give an example in excel sheet
Excelchat Expert 10/11/2017 - 03:10
Thank you
User 10/11/2017 - 03:10
Column A i have
Excelchat Expert 10/11/2017 - 03:10
Oh
Excelchat Expert 10/11/2017 - 03:11
How many time 112333
User 10/11/2017 - 03:11
Now i want in column B to be like i'll enter now
User 10/11/2017 - 03:11
Got it?
Excelchat Expert 10/11/2017 - 03:11
Clue
User 10/11/2017 - 03:12
Basically i want a number next to it,found first = 1 twice = 2 and go on
Excelchat Expert 10/11/2017 - 03:12
No Problem
Excelchat Expert 10/11/2017 - 03:12
Could you please wait for a moment
Excelchat Expert 10/11/2017 - 03:13
Thank you
User 10/11/2017 - 03:13
Sure
User 10/11/2017 - 03:13
Excelchat Expert 10/11/2017 - 03:15
Got it
Excelchat Expert 10/11/2017 - 03:16
Please do not forget to rate our session
Excelchat Expert 10/11/2017 - 03:16
Thank you
Excelchat Expert 10/11/2017 - 03:16
=COUNTIF(\$A\$1:A2,A2)
User 10/11/2017 - 03:18
You are AMAZING
User 10/11/2017 - 03:18
Thanks a million!

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.