» Finding Every Third Number and Returning the Largest of Them
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
We want to scan List1 (Column A) for every third number and then determine which of them is the largest.
Solution:
Use the MAX, IF, MOD, and ROW functions as shown in the following Array formula:
{=MAX(IF(MOD(ROW($A$2:$A$10)-ROW($A$2)+1,3)=0,$A$2:$A$10))}
Book Store:
Recommended Books:
- Accounting the Easy Way
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- The 11 Immutable Laws of Internet Branding
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Analyzing Markets, Products, and Marketing Plans
No comments have been submitted.
