Add ID number to list of names where names are repeated. ID number to be repeated for same name.

gregfthompson used Ask the Experts™
The attached excel file contains a list of newspapers, where the name is repeated against a location Id.

The requirement is to add an ID number (starting at 8000) in Column E, against each different newspaper name shown in Column D.
Where the newspaper name is repeated, the ID number will be repeated.

The first three newspapers, in 278 rows, have been completed manually as an example with the ID in column E.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
E2: 8000
E3: =IF(D3=D2,E2,E2+1)

Copy E3 down all the way.


Thanks. Worked perfectly!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial