VLookup

[snowman8271]

Hi guys,

so here is what I'm trying to do. I have a column of 10 digit position numbers. I have it formatted to text because some numbers start with 0.

What I need to happen is to determine if individuals are "double slotted" against the same position number. I was attempting to use VLookup to check the entire column for duplicates and display the duplicate name(s) in another column.


So... check column E for duplicate position numbers. If duplicate is found, display name(s) associated with duplicate (column G) in a new column.

IF(LOOKUP(E2,E:E,G:G), G2, 0) something along these lines? But G2 needs to be Gwhatever is the name associated with the duplicate position number.

Thanks for the help!!

 

[oldbrewer]

name	number	duplicate
alf	23
bill	25	bill
colin	27	colin
dave	29				a simple countif identifies the duplicates
ed	31				and puts in the names
fred	27	fred
georhe	35
harry	37
ian	39
james	25	james
keith	43
			formula in C2
			=IF(COUNTIF($B$2:$B$12,B2)>1,A2,"")

<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[snowman8271]

Hey oldbrewer,

I'm gonna modify your chart so it shows what I'm looking for. I need it to show the other duplicate results minus the one its actually associated with.

Thanks!

name	number	duplicate
alf	23
bill	25	dave, james
colin	27	fred
dave	25	bill, james			a simple countif identifies the duplicates
ed	31				and puts in the names
fred	27	colin
georhe	35
harry	37
ian	39
james	25	bill, dave
keith	43
			formula in C2
			=IF(COUNTIF($B$2:$B$12,B2)>1,A2,"")

<tbody>
</tbody>