Good example. It is important to listen to his instruction at 1min 35 seconds to use the CTRL-SHIFT-ENTER command to instruct Excel or Google Sheets (you need turn on shortcut keys in Google Sheets) to instruct that this is an array. I did this with an array in Google Sheets it produced this formula =ArrayFormula(min(if(H34:H47>0,H34:H47))) when I hit CTRL-SHIFT-ENTER and it reformated the formula with the =ArrayFormula() automatically added to the formula to make it work.
Sir , I have data in differrnt column , how to use min functiion if have data in column b , d , f n neet retrieve minimum value from columm b d f and excluding zero
@@MrRavi-zb6mz You are not very polite. You did not say thank you for free videos, and then you demand that I answer when I am asleep!?!?! This is a free video education site, not a Excel Question and Answer Site. I get 100s of questions every day and I am just one man. For around the clock Excel Questions try: mrexcel.com/forum. Nevertheless, your question is interesting. But my question for you is: Do you mean minimum negative value of -10, -2, -1 is -10 or do you mean maximum negative value of -10, -2, -1 is -1? And what version of Excel do you have, because the solution is different in different versions.
Good example. It is important to listen to his instruction at 1min 35 seconds to use the CTRL-SHIFT-ENTER command to instruct Excel or Google Sheets (you need turn on shortcut keys in Google Sheets) to instruct that this is an array. I did this with an array in Google Sheets it produced this formula
=ArrayFormula(min(if(H34:H47>0,H34:H47)))
when I hit CTRL-SHIFT-ENTER and it reformated the formula with the
=ArrayFormula()
automatically added to the formula to make it work.
Thanks for the google sheets tip!
you are number one in the world. respect
I am glad that you like the video, Asa!!!
You are welcome!
Omg you save my lifee, like and subscribed
I'm trying to identify numbers positive and/or negative closeted to Zero. Can you help me.
Sir , I have data in differrnt column , how to use min functiion if have data in column b , d , f n neet retrieve minimum value from columm b d f and excluding zero
Thank You Modi
Genius. Thank you.
Thanks. Just what I'm looking for.
Thanks Mike
big help, many thanks
How we can find minimum negative value in same case?
?
Reply soon?
@@MrRavi-zb6mz You are not very polite. You did not say thank you for free videos, and then you demand that I answer when I am asleep!?!?! This is a free video education site, not a Excel Question and Answer Site. I get 100s of questions every day and I am just one man. For around the clock Excel Questions try: mrexcel.com/forum. Nevertheless, your question is interesting. But my question for you is: Do you mean minimum negative value of -10, -2, -1 is -10 or do you mean maximum negative value of -10, -2, -1 is -1? And what version of Excel do you have, because the solution is different in different versions.
Hey- great video- thanks a lot!
You are welcome!
thank you
Thanks, bud!
Thank you