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
You can use a combination of the CountIf function and dynamic cell references to accomplish this.
I posted a video HERE demonstrating how this can be done.
Page :
1
There are no replies made for this post yet.
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »