Extract existing IDs of entries repeated in a worksheet in a separate column

Hi,
I have some test scripts that I track in an excel sheet. Each script has several attributes like status, module that it belongs to etc. Some scripts are common among other modules as well. So, from a script writing stand-point, the tester needs to know that the script he/ she are writing, which other modules require it. So that he/ she may save some time and reuse the existing scripts. So, I need some help in writing an excel macro/ solution to the following:

1. In a new column named ‘Common with’ the solution searches the script name column and wherever it finds same name script (regardless of module), that script’s ID is noted and written in the ‘Common with’ column.
2. If more than one repetition is found then, separate the IDs in the common with column with commas.
3. The solution must incorporate the logic that if a script’s repetition isn’t found then, ‘NONE’ is entered in the ‘Common with’ column.

So, I made a sample sheet and attached herewith. I would highly appreciate if you could please help me in this. Appreciate your help!

OK thanks..! Worked very well. Could you suggest, where to edit, if I want that ID of a script with 'Removed' status (regardless of its repetition) is not entered in the 'Common with' column?

Sure. So, if a script has a status of 'Removed' then, I don't want that script's ID listed in the 'Common with' column. Is that possible..?

Thanks a lot..!!!

Thanks..! Worked. I just added a little change:

=IF(C2="Removed","NA",IF(TRIM(SUBSTITUTE(" "&ACONCAT(IF($B$2:$B$16=B2,$A$2:$A$16,"")," ")&" "," "&A2&" "," "))="","None",SUBSTITUTE(TRIM(SUBSTITUTE(" "&ACONCAT(IF($B$2:$B$16=B2,$A$2:$A$16,"")," ")&" "," "&A2&" "," "))," ",", ")))

One more thing..when the logic searches the test script name column, then, it should list ID(s) of the duplicate script name. However, it also lists the parent entry as well. I mean, for example, if first row has script id = '1' and script name is 'ABC'. The logic must search the script name column and if it finds the same name script in rows 25 and 25 below, then it should list the numbers 24 and 25 respectively and not 1, 24, 25...!

Could you suggest how to facilitate this?