Try to search your question here, if you can't find : Ask Any Question Now ?

How to return lowest value in a filtered list greater than zero

HomeCategory: stackoverflowHow to return lowest value in a filtered list greater than zero
rupesh asked 3 weeks ago

I need help creating a formula in excel 2016 that will show me the lowest/smallest value in a filtered list that is greater than zero. There may be duplicates. For example:

Lowest value: should be 1.5

1.5

0.0

1.8

2.9

1.2 (hidden/filtered out)

1.5

3.4

1.3 (hidden/filtered out)

0.0 (hidden/filtered out)

Any help would be greatly appreciated.

1 Answers
Best Answer
Mikhail answered 3 weeks ago
Your Answer

1 + 13 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com