Log in  \/ 
x
or
x
x
Register  \/ 
x

or

normal How to get the nymbers if a value repeats in a column.

More
11 months 2 weeks ago #1639 by izzy-analytics
Replied by izzy-analytics on topic How to get the nymbers if a value repeats in a column.
You can use a combination of the CountIf function and dynamic cell references to accomplish this.

I posted a video YouTube demonstrating how this can be done.

Please Log in or Create an account to join the conversation.

More
11 months 4 weeks ago #1620 by Kailas Bairagi
I want to get a serial number every time a value repeats in the column.as given in the below example.
Fruit name Desired results
Apple 1
Guava 1
Mango 1
Banana 1
Apple 2
Guava 2
Apple 3
Guava 3
Mango 2
Apple 4

Lisa6538

Please Log in or Create an account to join the conversation.

Moderators: jaychivoExcelfansqiuhongkun