Hi Guys,
Can you please help with this one?
I would like to know the number of instances the initials of our engineers appear in column J
I am hoping that this info can then be displayed within a league table / pivot table of some sort in descending order?
If you could help I would appreciate it.
Are you open to using a couple helper columns? Such as using the advance filter > copy to another location > Unique records only
then do a countif stmt based on that list? then you can rank them after that.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
here is your data back using columns Q R and S for counts and ranks.
Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks