» Checking for the Presence of Specified Values Within a Range
CATEGORY - Excel Array Formulas
VERSION - All Microsoft Excel Versions
Creating a formula that will return TRUE if each number in column E appears at least once in the range A2:C6.
If any of the specified numbers are missing, the formula will return FALSE.
Solution:
Use AND and COUNTIF functions in the following Array formula:
{=AND(COUNTIF(A2:C6,E2:E10))}
Book Store:
Recommended Books:
- Accounting for Dummies
- Definitive Guide to Excel VBA
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Financial Reporting and Analysis (2nd Edition)
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Accounting Principles, with CD, 6th Edition
No comments have been submitted.
