Notifications
Clear all
Topic starter
Hello
I need assistance i want excel to return the name associated with highest number meeting the condition that is greater than 0% and less than or equal to 20%. In the excel table attached the name i wish to be returned is Judith since its 19% the highest in the list but not over the target which is 20%.
Find attached.
Posted : 15/11/2019 3:06 am
You can use an array formula:
=INDEX(A2:A10,MATCH(MAX(IF(B2:B10>0,IF(B2:B10<=B1,B2:B10))),B2:B10,0))
entered with Ctrl+Shift+Enter.
Posted : 15/11/2019 8:18 am
