ohhaykfrankk
New member
- Joined
- Jan 29, 2017
- Messages
- 33
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2010
My table is as such:
Column B: Names
Column E: Remainder
Column K: Criteria is True or False.
I need a formula that searches for TRUE in column K and finds the lowest number in column E (some FALSE numbers are lower though) and returns with the name in column B.
Can anyone help? Thank you in advanced.
Column B: Names
Column E: Remainder
Column K: Criteria is True or False.
I need a formula that searches for TRUE in column K and finds the lowest number in column E (some FALSE numbers are lower though) and returns with the name in column B.
Can anyone help? Thank you in advanced.