0

I would like to use a formula to automatically set a position of a group in a table entry.

This can also be seen as an autoincremental ID which needs to be unique only in the group it is associated with.

The formula would generate the numbers in the Position column as pictured below:

Target

Is there any way to do this without using VBA? Thanks for your help

weberc2
  • 7,423
  • 4
  • 41
  • 57
DavidD
  • 1,009
  • 1
  • 14
  • 29

1 Answers1

3

add the following in Column C and drag down:

=COUNTIF($A$2:A2, A2)
InContext
  • 2,461
  • 12
  • 24