I have a table with location and Item information. I want to identify the missing item between the location.
Note: There will be duplication in the item.
My Date
| Location |
Items |
| Site A |
Pen |
| Site A |
Pen |
| Site A |
Ball |
| Site A |
Ball |
| Site A |
Bat |
| Site A |
Bat |
| Site A |
Bat |
| Site B |
Pencil |
| Site B |
Pencil |
| Site B |
Pen |
| Site B |
Bat |
| Site B |
Pen |
| Site B |
Pen |
| Site B |
Bat |
Expected output in the text box:
The 2 item Missing in the list are Ball , Pencil.
I could not modify my script. So I would like to do this with expression. Is there any possible way?
