I have a table that looks basically like this:

Name---|---Asset number---|---Barcode number---|---Serial number--|
B0001--|--A1234567---------|----E54321-------------|----M2345----------|
B0002--|--A1234568---------|----E54320-------------|----M2346----------|
B0003--|--A1234569---------|----E54321-------------|----M2347----------|
B0004--|--A1234567---------|----E54319-------------|----M2348----------|


I figured out how to make the table display when values in any of the columns are duplicated, using:

=IF( COUNTIF(B:B,B4)>1, "Duplicated !","")

(as the Asset column is column B and starts on line 4)

Using that macro (modified and put in columns E, F, and G), this is what the table ends up looking like:

Name---|---Asset number---|---Barcode number---|---Serial number--|--Asset dupe-|-Barcode dupe-|--Serial dupe-|
B0001--|--A1234567---------|----E54321-------------|----M2345----------|-Duplicated !-|--Duplicated !--|-----------------|
B0002--|--A1234568---------|----E54320-------------|----M2346----------|-----------------|-------------------|-----------------|
B0003--|--A1234569---------|----E54321-------------|----M2347----------|-----------------|--Duplicated !--|-----------------|
B0004--|--A1234567---------|----E54319-------------|----M2348----------|-Duplicated !-|-------------------|-----------------|


My question is this: is there a way I can make the table display that there are duplicated lines, and then give the A column values of the duplicated lines?

For instance, if I wanted to find all the places where there are duplicated values in column B, could I get it to say something along the lines of "Duplicated in B0001 and B0004"?


Hopefully that makes sense. Thanks in advance for any help you can offer!