snowman8271
New Member
- Joined
- Mar 20, 2018
- Messages
- 3
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!!
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!!