Excel Forum
Similar Content
Vlookup to Return All Matching Results
Tutorial: Here is an Excel formula that will act like a Vlookup that returns every matching result ...
Odd or Even Row Formulas in Excel
Tutorial: Formulas to determine if the current cell is odd or even; this allows you to perform speci...
Vlookup Macro to Return All Matching Results from a Sheet in Excel
Macro: This Excel Macro works like a better Vlookup function because it returns ALL of the matchi...



Excel Magic Trick 622: Array Formula to Return Even Row Data Only


See an Array Formula to Return Even Row Data Only that uses the SUMPRODUCT, MOD, IF, ROWS, INDEX, SMALL, and ROW functions.





Got a Question? Ask it Here in the Forum.