If your values are in ColA (from A2 down), then in B2 put:
=A2 & "_" & RIGHT("000" & COUNTIF(A$2:A2,A2), 3)
and fill down.
More Related Contents:
- vba excel: how to copy characters from a cell to another
- What is the default scope of worksheets and cells and range?
- Is there any event that fires when keys are pressed when editing a cell?
- Does the VBA “And” operator evaluate the second argument when the first is false?
- Split cell values into multiple rows and keep other data
- Save each sheet in a workbook to separate CSV files
- Is VBA an OOP language, and does it support polymorphism?
- Export each sheet to a separate csv file
- Detect if range is empty
- Checking if a worksheet-based checkbox is checked
- Assign keyboard shortcut to run procedure
- Faster way to remove ‘extra’ spaces (more than 1) from a large range of cells using VBA for Excel
- Uncheck all checkboxes across entire workbook via CommandButton
- return csv file as recordset
- VBA workbooks.Close without being prompted to if the user wants to save?
- Extract Data from Word Document to an Excel SpreadSheet
- VBA equivalent to Excel’s mod function
- Copy a selected range to another worksheet
- Excel macro – paste only non empty cells from one sheet to another
- The MacScript function is not working well in Office for Mac 2016! Any ideas?
- Pointers needed for speeding up nested loop macro in VBA
- ‘1004’: “The sort reference is not valid.”
- Select entire column in table using Excel VBA
- Create hyperlink to another sheet
- Reducing WithEvent declarations and subs with VBA and ActiveX
- Convert Early Binding VBA to Late Binding VBA : Excel to Outlook Contacts
- Delete all data rows from an Excel table (apart from the first)
- Excel Hide/Show all tabs on Ribbon except custom tab
- Macros Not Showing Up in Macro Table
- Excel VBA Run-time Error ‘32809’ – Trying to Understand it