add extra characters to duplicate text

I am using DGET to look through a table. First there is a dropdown box that has the values of column B to choose from. Once you choose... It plugs in the rest of the information from that row to the cells scattered around the sheet where they belong. The problem comes up when there are items in column B that are identicle. Since the rest of the data on the row is unique to the other cells in the row with the identicle data in column B. The easiest way I can think of to bypass this problem would be to find a way to search all of column B of the worksheet "Data2" and on the first instacce of duplicate text, add a character such as "*". on the next duplicate add "**" Im not sure if this is even possible so Im open to any ideas or suggestions.

for example

column B column C
test one
test two
test three
real one


so I would need B1 to stay test
B2 to become test *
B3 to become test**


thanks in advance to anyone taking the time to try this

That looks like a good starting point. Now where to go from there ? Ill attach the file im working on. The count canbe helpful but the actual text cannot stay the same because of the dget function. Maybe you can look at my spreadsheet and have a clearer understanding of what im talking about. On the "extracted data2" sheet use the dropdown to select an item that has a duplicate from the "data2" sheet. ACC-004 is one of these. I then get all kinds of errors on my layout because of it being a duplicate copy. Although the columnB is a duplicate I still need the other information from the row.

thank again

Scaffolds_validation.xls