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).
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:![]()
Please Login or Register to view this content.
=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