pochie2741
New Member
- Joined
- Dec 8, 2021
- Messages
- 9
- Office Version
- 2019
- Platform
- Windows
Hello Everyone,
Need help please for a formula under Results Column:
Need help please for a formula under Results Column:
- If the ticket numbers are the same (with duplicates below it), results will show combination of the fruits separated by a slash. The result should only show on the first ticket number. The rest of the same ticket numbers will show as blank.
- If the ticket number does not have duplicate tickets below it, it will show the assigned fruit.
Ticket | Fruit | Result |
123 | Apple | Apple/Orange/Mango |
123 | Orange | |
123 | Mango | |
456 | Banana | Banana |
789 | Apple | Apple/Banana |
789 | Banana | |
321 | Grapes | Grapes |