98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Creating a Hierarchy of Names
Creating a Hierarchy of Names
Resolved · High Priority · Version 2007
Wed 28 Nov 2012, 12:22Delegate Gregory said...
Gregory has attended:
Excel Intermediate course
Excel VBA Intro Intermediate course
Excel Advanced course
Excel Advanced course
Creating a Hierarchy of Names
I am trying to create a list of names with the purpose ordering these in terms of 'experience'. The purpose of this being is that the more experienced you are, the greater amount of tasks you can full fill.
I imagine I would need to create a variable(s) that associates tasks with a number/index and then associate this index with each person and then organises them in terms of experience.
However, I am unsure of where to begin.
Fri 30 Nov 2012, 11:42Trainer Gary said...
RE: Creating a Hierarchy of Names
Hi Gregory
Thanks for getting in touch.
Let me check that I understand your query:
* there are a list of tasks, which have a value for experience (so Managed a Project = 5, Completed Profit & Loss = 6 etc).
* you can then add these values together to give an accumulated "experience" score.
I'm not sure whether VBA is necessary for this outcome. Perhaps you could build a table in Excel, and use a VLOOKUP to query that table, returning the index associated with the task. Using a PivotTable on this summary data will probably give you the answer you need.
Check that I've understood the scope of your problem so far, and we can explore what you might need from here.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Wed 5 Dec 2012, 19:10Delegate Gregory said...
RE: Creating a Hierarchy of Names
Hi Gary
Thanks for getting back so soon. In regards to my original question, I realised I did not explain in as well as I should have.
What I want to do is designate tasks out to a group of people. the problems I have are as follows;
i) Not everyone within the group can complete all the tasks required (some tasks are more advanced that cannot be completed by individuals in the group with limited experience)
ii)Each individual can only be assigned ONE task.
I think I have an idea using the FIND/MATCH function as well as a FOR NEXT LOOP.
Again I think this will require using variables as I want to rotate the tasks for each individual for say each week.
Cheers
Greg
Wed 5 Dec 2012, 21:02Trainer Gary said...
RE: Creating a Hierarchy of Names
Hi Gregory
Thanks for your reply. You said you had an idea; would you be able to reply with the loose structure you have in mind?
I can then offer some advice how to refine this.
Kind regards
Gary Fenn
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 13 Dec 2012, 11:47Trainer Cindy said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Thu 20 Dec 2012: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Converting an American date format to European using FormulaExcel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following. |
