Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

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

More
4 days 11 hours ago #1639 by Israel
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.

  • Angel Alvarado
  • Topic Author
  • Offline
  • New Member
  • New Member
More
2 weeks 4 days ago #1620 by Angel Alvarado
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

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

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Moderators: jaychivoQiu hongkunJay Chivo