I need a report that details the available staff and counts the number of shifts they are available for. The report should only list the available staff as per the example. Looking for a function based solution.
Lookups Match.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Staff | Available Shifts | Desired Report | |||||||
2 | Peter | Peter | Ken | Peter | Peter | 2 | ||||
3 | Harry | Ken | Mary | Tom | Ken | 2 | ||||
4 | Fred | Mary | Mary | 2 | ||||||
5 | Mary | Tom | 1 | |||||||
6 | Ken | |||||||||
7 | Tom | |||||||||
Sheet13 |