» Finding Every Third Number and Returning the Largest of Them
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Problem: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:
- Microsoft Windows XP Step by Step (With CD-ROM)
- Analyzing Markets, Products, and Marketing Plans
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Not-for-Profit Accounting Made Easy
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
No comments have been submitted.
