sam aljanabi
New Member
- Joined
- Jul 24, 2017
- Messages
- 2
Hi ,
I need your help, i have a sheet that has several entries (columns and row, sample below) i would like to retrieve the header label based on a certain cell value (i.e. pending) and place the labels in the last cell (who is pending).
in other words, if there is a date in the cell then its ok otherwise raise a flag and point out that the ticket number for that individual is still pending and that ticket is not complete.
The output in the last cell should be as follows:
- First ticket [PETER, DAVID]
- Second ticket [SAM]
- Third ticket [ jack, peter, mark]
- Last ticket [ALL COMPLETE]
<tbody>
</tbody>
Thanks
Sam
I need your help, i have a sheet that has several entries (columns and row, sample below) i would like to retrieve the header label based on a certain cell value (i.e. pending) and place the labels in the last cell (who is pending).
in other words, if there is a date in the cell then its ok otherwise raise a flag and point out that the ticket number for that individual is still pending and that ticket is not complete.
The output in the last cell should be as follows:
- First ticket [PETER, DAVID]
- Second ticket [SAM]
- Third ticket [ jack, peter, mark]
- Last ticket [ALL COMPLETE]
ticket number | SAM | JACK | PETER | DAVID | MARK | Who is pending |
123456 | 12-10-2016 | 2-5-2014 | pending | pending | 3-5-2015 | |
123457 | pending | 2-8-2015 | 2-9-2015 | 2-6-2017 | 5-9-2.014 | |
123458 | 2-7-2011 | pending | pending | pending | pending | |
123459 | 10-2-2015 | 4-9-2016 | 7-8-2014 | 7-5-2013 | 7-3-2017 |
<tbody>
</tbody>
Thanks
Sam