I'm trying to eliminate a number of duplicate serial numbers in a worksheet. The duplicates have numbers and test and I'd like to add a - and sequential number for the duplicates. Once I get to the end of the duplicates and another batch of duplicates begin I'd like to start - and sequential number all over until I get to the bottom of the duplicates. Spreadsheet attached with what I see and what I want the output to look like. Thanks so much for your help!
maybe this... =IF(COUNTIF($B$2:B2,B2)=1,B2,B2&"-"&COUNTIF($B$2:B2,B2)-1)
in E2 dragged down.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
In column C...
=IF(COUNTIF($B$1:B2,B2)>1,B2&"-"&COUNTIF($B$1:B2,B2)-1,B2)
Copy down.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Re: Increment duplicate numbers by adding a - and sequential number
Thanks to both of you for providing an easy way to eliminate these duplicates! I tried both solutions and both worked great.
You are welcome and thanks for the rep
If you are satisfied with the solution provided. Please mark the thread as solved, by using thread tools found at top of your initial post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks