LinkBack URL
About LinkBacks
Gents,
har to believe this isn't simple. I want to return a minimum vales in a row that is greater than zero.
A1 A2 A3 A4 A5 A6 A7
0 4 0 3 2 0 6
Is there a way to incorporate an "if" statement into the = Min() statement?
Thanks !!
Gents,
har to believe this isn't simple. I want to return a minimum vales in a row that is greater than zero.
A1 A2 A3 A4 A5 A6 A7
0 4 0 3 2 0 6
Is there a way to incorporate an "if" statement into the = Min() statement?
Thanks !!
Try this array formula
=MIN(IF(A1:A7>0,A1:A7))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Row\Col
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Here's another one...
=AGGREGATE(15,6,A1:A7/(A1:A7>0),1)
The equivalent array formula is slightly faster to calculate but the difference is negligible.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Worked like a charm !!!!
Your' re welcome and thank you for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks