bubbisthedog
New Member
- Joined
- Feb 6, 2012
- Messages
- 15
- Office Version
- 2016
- Platform
- Windows
Rich (BB code):
=MIN(IF('Sheet1'!$A:$A=$B4,'Sheet1'!$P:$P,""))
B4 is single condition currently. P:P is range I'm searching to find minimum value, only when A:A range includes B4 value.
I Shift+Ctrl+Enter to create array formula that finds minimum value. Now I need to add another condition for column AK:AK, and cannot figure it out.
Please help.
Thank you!!!!