Table Matrix:
Table Priority Order.
If i put numbers in the Jobs to assign which job takes priority of 1. i would like for this to count how many 1s are there. which i have done by =COUNTIF(Matrix!$B$3:$K$12,7)
However i would like the table in priority to update with the most priority job.
So it could be job 1, job 5, job 3.
If anybody can help with changing the job orders depending on the high demand in jobs from the first table.
Hope that clears.
Thank you in advance.
Task List | Job 1 | Job 2 | Job 3 | Job 4 | Job 5 | Job 6 | Job 7 | Job 8 | Job 9 | Job 10 |
Job 1 | ||||||||||
Job 2 | ||||||||||
Job 3 | ||||||||||
Job 4 | ||||||||||
Job 5 | ||||||||||
Job 6 | ||||||||||
Job 7 | ||||||||||
Job 8 | ||||||||||
Job 9 | ||||||||||
Job 10 |
Table Priority Order.
If i put numbers in the Jobs to assign which job takes priority of 1. i would like for this to count how many 1s are there. which i have done by =COUNTIF(Matrix!$B$3:$K$12,7)
However i would like the table in priority to update with the most priority job.
So it could be job 1, job 5, job 3.
If anybody can help with changing the job orders depending on the high demand in jobs from the first table.
Hope that clears.
Thank you in advance.
