Hello Forum
I have a WB in which i keep compliance issues... column A has a list of employees, 1 for each issue (many duplicates)
I would like to implement an auto list of 1 of each employee from this duplicate list.
im horrible at explaining lol, but the attached should clear it up
Any help is greatly appreciated
For the Names...
K5=IFERROR(INDEX($A$1:$A$48,MATCH(0,INDEX(COUNTIF($K$4:K4,$A$1:$A$48),),0)),"")
copied down (adjust the ranges as needed)
You already have the countif() worked out
And your explanation was good, btw
Last edited by FDibbins; 12-30-2015 at 06:45 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Works Perfect... TY again FDibbins!
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks