Excel Forum



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.