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
take your time
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.
