Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
90
Views
Topic starter
I require assistance with a formula to return the adjacent cell of a maximum number in a range when two criteria are satisfied.
e.g return the bonus salary(adjacent cell) of an employee who earns the highest[basic salary](maximum number in range) given that the person is black(criteria) and female(criteria).
Posted : 13/03/2020 7:01 am
Can you please supply an example in a worksheet?
Purfleet
Posted : 13/03/2020 10:21 am
Topic starter
https://drive.google.com/open?id=1bE7MD2cWo0bgioiThXcRTQU9nU_Ig9mF Please see attached on link
Posted : 14/03/2020 7:43 am
