Hey,
Please help, a little urgent!
Need a way to rank a table based on multiple criteria. This is what the table looks like
<tbody>
</tbody>
Trying to create a list of what should be prioritized first. The idea of ranking is anything that is Urgent 1 should be ranked first, depending on largest time lapsed, after which, anything with urgent 2 should get prioritized only if greater than 48 (time lapsed), after which the oldest should get ranked first.
I know a little complicated, trying to figure out for a couple days now and hitting deadline, any help appreciated!!!
Thanks in advance guys
Please help, a little urgent!
Need a way to rank a table based on multiple criteria. This is what the table looks like
Appt | Schedule | Time lapsed | Urgent1 | urgent2 | rank | |
10 |
<tbody> </tbody> | 72 | 4 | |||
16 | 11/1/2015 23:00 | 70 | Y | 3 | ||
21 | 11/2/2015 04:00 | 65 | Y | 1 | ||
25 | 11/2/2015 15:00 | 54 | 5 | |||
30 | 11/3/2015 00:00 | 45 | Y | 2 | ||
31 | 11/3/2015 06:00 | 39 | Y | 6 | ||
35 | 11/3/2015 12:00 | 33 | 7 |
<tbody>
</tbody>
Trying to create a list of what should be prioritized first. The idea of ranking is anything that is Urgent 1 should be ranked first, depending on largest time lapsed, after which, anything with urgent 2 should get prioritized only if greater than 48 (time lapsed), after which the oldest should get ranked first.
I know a little complicated, trying to figure out for a couple days now and hitting deadline, any help appreciated!!!
Thanks in advance guys