Hi
I have a spreadsheet with these columns
Item
Staff
Group
Value
Status
I need something that can do this:
1. Staff priority - Zak, Mo, Di, Sam
2. The spreadsheet contains items that are the responsibility of each Staff. Each item belong to one or more groups of products with a commercial value.
3. Staff leave and items re-assigned randomly resulting in more than a Staff per item. I am now cleaning the spreadsheet and assigning an item per Staff .
4. The formula should help as follows:
If an item has Zak:
add Yes in the status column
If an item has Zak and and Sam, add Yes in the Zak row and No in the Sam row;
If an item has and Mo, add Yes in the Zak row and No in the Mo row;
If an item has and Di, add Yes in the Zak row and No in the Di row;
If an item has no Zak and has:
Mo and Sam, add Yes in the Mo row and No in the Sam row;
Mo and Di, add Yes in the Mo row and No in the Di row;
Di and Sam, add Yes in the Di row and No in the Sam row;
only Sam, add Yes in the Sam row;
only Mo, add Yes in the Mo row;
only Di, add Yes in the Di row;
I attach the sample spreadsheet.
Thanks
Raury
Bookmarks