At a loss: Finding & modifying duplicate cells
I've managed to automate enough things to make life easier for myself, however I'm completely without a clue regarding what I'd like to do now.
Simple 2 column sheet. Example:
The Work I'd like to automate
Many users have two or more ID numbers (column B), so I have sections of the sheet that look like this:
For my purposes, I have to add incemental numbers to column A like this:
Caliban Doc 2|1247
Caliban Doc 3|1295
I'd love to not have to do that manually as the sheet is almost 600 lines long and the majority of users have multiple lines.
Any help is greatly appreciated.