» 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:
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Microsoft Access Version 2002 Step by Step
No comments have been submitted.
