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?
Cross posted:
http://www.mrexcel.com/forum/showthr...ltiple-Results
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
there's rules about posting on to separate excel forums?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks