Hello,
Is it feasible to use Rank with Index & Match.
I am trying to achieve:-
Person rank based on skill level for a task
A3:A70 Name of Person
A2:G2 Task
B3:G70 Rank from 1 to 20, 1 being the best. This sheet is named " Skills"
Index & Match would transfer to another sheet named "Admin"via a userform, and will be used to call up any skill shortages for that team from "Skills"
I have looked through this forum and to be honest I am stuck. Some formulas given seem to fit the bill but I really don't understand them fully.
Can I sort within Index & Match as the skills are changeable? or do I sort then Index & Match??
Any help will much appreciated
Thanks
Steve
Is it feasible to use Rank with Index & Match.
I am trying to achieve:-
Person rank based on skill level for a task
A3:A70 Name of Person
A2:G2 Task
B3:G70 Rank from 1 to 20, 1 being the best. This sheet is named " Skills"
Index & Match would transfer to another sheet named "Admin"via a userform, and will be used to call up any skill shortages for that team from "Skills"
I have looked through this forum and to be honest I am stuck. Some formulas given seem to fit the bill but I really don't understand them fully.
Can I sort within Index & Match as the skills are changeable? or do I sort then Index & Match??
Any help will much appreciated
Thanks
Steve