Does anyone know a formula that can list names under a specific category? If there is how can i get the duplicate names enter as one under that specific category?
eg
lIST
stark:
Supervisor
SuperVisor
John
EDMA
Correct List
Stark:
Supervisor=2
John=1
Edma=1
Anyone?
Try this one
=IFERROR(INDEX($A$2:$A$6,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$6),,),)),"")
stark: stark: Supervisor Supervisor SuperVisor John John EDMA EDMA
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Employee List (2).xlsI've tried this formula and It does not work.......it gives me duplicates.
I've attached a sheet to show
May be you need to put Alkey's formula like this......
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
This is because you did not transpose formula correctly. This part COUNTIF($A$1:A1 should refer to the column in which formula is written. In your case it should be COUNTIF($J$1:J1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks