[solved] min function

[henry wirianto]

Dear All, i need help.
A1 = 2
A2 = 0
A3 = 4
I want to display the lowest number, but ve to be >0. And if posible using "=min()" func.
Thank you very much.

[sourabhg98]

If you have only positive numbers in your range try this formula-

Please Login or Register  to view this content.

[henry wirianto]

If you have only positive numbers in your range try this formula-

Please Login or Register  to view this content.

Woow. It works. Thank you very much Mr. sourabhg98.

[sourabhg98]

Glad to know that helped!!

You can click on "Add Reputation" below my post to say thanks!!
Also, please take a moment to mark this thread as "SOLVED" from the "THREAD TOOLS" at the top of this page.

Regards

[sandy666]

I want to display the lowest number, but ve to be >0.

another way for positives, negatives and zeroes

Please Login or Register  to view this content.

[Khalidngo]

Hi Henry,
You have the solutions FWIW, Just adding this as you mentioned " if posible using "=min()" func."

=MIN(IF(A1:A10>0,A1:A10))

Array formula, to be entered with Ctrl+Shift+Enter

Blessing

[henry wirianto]

Hi Henry,
You have the solutions FWIW, Just adding this as you mentioned " if posible using "=min()" func."

=MIN(IF(A1:A10>0,A1:A10))

Array formula, to be entered with Ctrl+Shift+Enter

Blessing

I ve been looking for info about "ctrl+shift+enter", but cant find one. What is it exactly do when i press that all thatbutton. I cant find any info in excel help too.

[sourabhg98]

These are array formulas which need to be entered with CTRL+SHIFT+ENTER
Check these links out-
http://www.excel-easy.com/functions/array-formulas.html
https://support.office.com/en-IE/art...2-ecfd5caa57c7

[sandy666]

Glad to help, thanks for rep