Hi,
I need help on this and I hope that we can keep it to Excel not VBA.
1. I would like help in creating a formula that would check whether a particular ticket number appeared within the last 7 days. and
2. If the above condition is true, is the EMP # 1st to handle that particular ticket.
<tbody>
</tbody>
it would have been easier if only Excel had a "RANKIFS" function. Haha!
Thank you for your help.
I need help on this and I hope that we can keep it to Excel not VBA.
1. I would like help in creating a formula that would check whether a particular ticket number appeared within the last 7 days. and
2. If the above condition is true, is the EMP # 1st to handle that particular ticket.
Ticket | EMP # | Day | Ticket Occurrences | Did ticket occur within the past 7 days? If yes = 1 | Is EMP # 1st to handle ticket? If yes = 1 |
26402426 | 100102 | 29-Jun-14 | 5 | ||
26335978 | 100152 | 30-Jun-14 | 1 | ||
26418928 | 100156 | 1-Jul-14 | 1 | ||
26440649 | 100149 | 2-Jul-14 | 1 | ||
26451302 | 100130 | 3-Jul-14 | 1 | ||
26461054 | 100064 | 4-Jul-14 | 1 | ||
26402426 | 100064 | 5-Jul-14 | 5 | ||
26478696 | 100130 | 6-Jul-14 | 1 | ||
26487400 | 100130 | 7-Jul-14 | 1 | ||
26402426 | 100064 | 8-Jul-14 | 5 | ||
26507912 | 100064 | 9-Jul-14 | 1 | ||
26517702 | 100064 | 10-Jul-14 | 1 | ||
26527528 | 100177 | 11-Jul-14 | 1 | ||
26537573 | 100176 | 12-Jul-14 | 1 | ||
26546797 | 100130 | 13-Jul-14 | 1 | ||
26556225 | 100130 | 14-Jul-14 | 1 | ||
26402426 | 100130 | 15-Jul-14 | 5 | ||
26529592 | 100177 | 16-Jul-14 | 2 | ||
26587024 | 100175 | 17-Jul-14 | 1 | ||
26529592 | 100177 | 18-Jul-14 | 2 | ||
26606819 | 100176 | 19-Jul-14 | 1 | ||
26616371 | 100097 | 20-Jul-14 | 1 | ||
26402426 | 100042 | 21-Jul-14 | 5 | ||
26597903 | 100175 | 22-Jul-14 | 1 | ||
26659694 | 100080 | 24-Jul-14 | 1 | ||
26646268 | 100097 | 23-Jul-14 | 1 | ||
26671025 | 100116 | 25-Jul-14 | 1 | ||
26146601 | 100097 | 26-Jul-14 | 1 |
<tbody>
</tbody>
it would have been easier if only Excel had a "RANKIFS" function. Haha!
Thank you for your help.