I created a skills matrix with my team and was hoping to create a top 10 list of our highest scored skills vs lowest scored skills, and I am unsure of the best way to do so in Excel. I started by trying a filter (which I will include below).
A snippet of the matrix (smaller example)
image_2022-06-17_111437274.png
My FILTER I was using was to at least filter down to certain ranges. The G7 and I7 refer to thresholds that I set. The FILTER doesn't really do what I wanted, but it was the next best thing I could think of.
My ideal result would be something like this:Please Login or Register to view this content.
Top skills (X<5)
Accessibility Remediation
Apache
Accessibility Auditing
Accessibility (WCAG/508)
Bottom Skills (1<=X<=5)
.Net
Angular
ASP.NET MVC
No Skill (x<=0)
AWS
Ansible
Most of my google searches show me how to create a matrix or crosstab using pivots, but do not work with one that I already have.
Any ideas on methods to accomplish this?
Bookmarks