» How to find the minimum value in range while ignoring 0 value in Microsoft Excel
CATEGORY - Other Q&A Formulas
VERSION - All Microsoft Excel Versions
Data in range A1:A7
Column A Row1 100 Row2 0 Row3 300 Row4 50 Row5 500 Row6 0 Row7 700 Formula in cell B1: =SMALL(A1:A7,COUNTIF(A1:A7,0)+1) Result: 50
Book Store:
Recommended Books:
- A Mathematician Plays the Stock Market
- Keys to Reading an Annual Report (Barron's Business Keys)
- Marketing Plan: A Handbook with Marketing Plan
- Financial Peace: Revisited
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
No comments have been submitted.
