Adding Suffix To Cell Value

[VinchinzoB]

Hello,

I'm wanting a macro that will go down a list of cells all containing the same cell value and add an "A", "B", "C", etc in sequential order no matter where the cells is located. There may be blanks in between the cell values so I don't want letters added to the blank cells. Unfortunately, I don't have much of anything started as I'm not sure how to go about doing this.

[Kaper]

Just a good idea to start:

Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

Otherwise we don't know where the cells are, where the list of values is, etc.

[PaulM100]

You can use a non VBA solution that will take care of blanks as well:

=A1&IF(COUNTIF(A:A,A1)>1,MID("ABCDEFGHIJK",COUNTIF($A$1:A1,A1),1),"")