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!
Bookmarks