» 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
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:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Excel 2002 For Dummies®
- Writing Excel Macros with VBA, 2nd Edition
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
No comments have been submitted.

