I'm trying to product a list of people who haven't managed to get any lead for a month, I have some examples I have used for the purposes of testing (not the actual figures).
Team Leader No of Leads No of Sales
Steve 12 6
Claire 8 4
Tim 8 3
Total 28 13
I can get the following code to display the results I want, however it will only display one person, even if there are multiple people on zero:
=INDEX('[Team sheet.xlsx]Steves Team'!$B$5:$B$14,MATCH(0,'[Team sheet.xlsx]Steves Team'!$C$5:$C$14,0))
Anyone able to help?
Bookmarks