i would like to use the chart called ILU that has peoples ratings out of 100 to automatically update the tab called running plan in cells f2-f40 could you please help me?
added the wrong file in previous thread please ignore.
i would like to use the chart called ILU that has peoples ratings out of 100 to automatically update the tab called running plan in cells f2-f40 could you please help me?
added the wrong file in previous thread please ignore.
Your description doesn't really make it clear what you want... Please be SPECIFIC
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
On re-reading... is this what you need: an array formula in F3 copied down:
=IFERROR(INDEX(ILU!$B$2:$B$38,SUM(INDEX((ILU!$C$2:$AE$38=100)*(ILU!$C$1:$AE$1=D3)*ROW(ILU!$C$2:$AE$38),))-ROW(ILU!$C$2)+1),"")
Array Formulae are a little different from ordinary formulae in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.
Don't type the curly brackets yourself - it won't work...
Can you pl upload some examples in the file.
Yes that has worked great but i have realised i have made a mistake in two sections not matching the names in ILU to the running plan like BS RR and ECU.
Is it possible (getting extravagant here) but to add a situation in if i select a name to put him in holiday or absent it would remove them from the available list and then select the next best person? and a refresh button to automate it ?
I have set it deliberately to have the 29 stations with one key operator so that if everyone was at work the best people (with 100 rating) would be on that job, but if one of the staff with a 100 rating were on vacation or absent i would like it to select the next best person is that possible ?
regards
Last edited by D4gl15h; 03-05-2017 at 06:46 AM.
I was able to make a lucky guess the first time round. Now you have me in a flat spin. I don't understand your most recent request, because I haven't a clue what you are trying to achieve.
can you explain the logic (with reference to sheet rows and columns) behind your request?
Hi
sorry for not explaining properly. the ILU sheet is like a team sheet so certain people can do certain jobs but they can do certain jobs better than others.
you have got it right what i wanted in terms of putting the best person for that job on that job with a ranking of 100.
but if possible if that person with a ranking of 100 is on holiday it would select the next best person to do that job eg on the ILU chart C.McGreggor has a 100 rating on 75R cell X10 but if he was off i would like it to select D.Swan who has the next highest rating on that job in cell X16.
i know to do so i would need to be able to disable an operators availability (is that possible?) if so would it be possible to add a refresh button of some sort so i could select operator for vacation removing him from availability thus selecting the next highest rated staff member.
in the columns i have set it out there is never duplicate skill ratings.
hope that makes sense.
regards
Yes. I think. I'm not the most elegant provider of solutions... Someone really good at Excel might have a better way. Myself, I'd keeo your score sheet as is. Id have a separate list of who is on holiday and then replicate the list, setting the score of anyone on holiday to blank.
It might work.... Would that be OK for you (I'm not back here for 12 hours+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks