I need to number rows based on duplicate values in a different row. i.e.
- Column A (the #) —Column B (The Duplicates)
- 1------------------------CC111
- 2------------------------CC111
- 3------------------------CC111
- 1------------------------AE231
- 2------------------------AE231
- 1------------------------BB456
- 1------------------------DD444