» 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:
- Microsoft Windows XP Inside Out
- The Basics of Finance: Financial Tools for Non Financial Managers
- Accounting for Dummies
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Learn MS Excel 2002 VBA/XML Programming
No comments have been submitted.
