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
Avatarrupesh asked 5 months 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
AvatarMikhail answered 5 months ago
Your Answer

14 + 1 =

Popular Tags

WP Facebook Auto Publish Powered By : XYZScripts.com