Hello all,
I am looking to find the processor who has last processed the ticket. Also I would like to use only formula tool(If else) to get the output.
Can anyone help....
Input :
| Ticket | Processor | Date |
| 123 | ABC | 6/25/2023 |
| 123 | ABC | 6/25/2023 |
| 123 | DEF | 6/26/2023 |
| 126 | ABC | 5/1/2023 |
| 126 | ABC | 5/21/2023 |
| 126 | ABC | 5/25/2023 |
| 126 | GHI | 6/25/2023 |
| 130 | ABC | 5/1/2023 |
| 130 | ABC | 5/21/2023 |
| 130 | ABC | 5/25/2023 |
| 130 | DEF | 6/25/2023 |
| 135 | GHI | 5/25/2023 |
| 135 | GHI | 5/27/2023 |
| 135 | GHI | 5/25/2023 |
| 135 | ABC | 5/25/2023 |
| 135 | ABC | 5/25/2023 |
| 135 | DEF | 5/25/2023 |
Output:
| Ticket | Processor | Date | Last Processor |
| 123 | ABC | 6/25/2023 | DEF |
| 123 | ABC | 6/25/2023 | DEF |
| 123 | DEF | 6/26/2023 | DEF |
| 126 | ABC | 5/1/2023 | GHI |
| 126 | ABC | 5/21/2023 | GHI |
| 126 | ABC | 5/25/2023 | GHI |
| 126 | GHI | 6/25/2023 | GHI |
| 130 | ABC | 5/1/2023 | DEF |
| 130 | ABC | 5/21/2023 | DEF |
| 130 | ABC | 5/25/2023 | DEF |
| 130 | DEF | 6/25/2023 | DEF |
| 135 | GHI | 5/25/2023 | GHI |
| 135 | GHI | 5/27/2023 | GHI |
| 135 | GHI | 5/25/2023 | GHI |
| 135 | ABC | 5/25/2023 | GHI |
| 135 | ABC | 5/25/2023 | GHI |
| 135 | DEF | 5/25/2023 | GHI |
