Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Friday, 31 May 2019
  1 Replies
  6.1K Visits
0
Votes
Undo
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
4 years ago
·
#1953
0
Votes
Undo
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.