Lookup employee number and see duplicates as well
Howdy,
I have a list of employee numbers and names. Sometimes the employee is on loan to another division and their serial number is imputed twice.
I want to look up an employee number and have a table populate all the unique times the employee number appears.
Thanks.
find employee with duplicates.xlsx
Try this in J4
=IFERROR(INDEX(B$2:B$100,SMALL(IF($A$2:$A$100=$J$1,ROW(B$2:B$100)-1),ROW(B1))),"")
Copy down and across.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Maybe I'm doing something wrong. I placed the formula in J4 and dragged down. When I try employee number "1" it returns the wrong name.
I would like to type "1" in J1 and then all three times "1" appears uniquely will come up.
I appreciate the help though.
Wait, it's an array formula. Ok, this is great. I appreciate it sir.
Apologize that i didn't mentioned that this is an ARRAY formula. See my signature for this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks