Excel Magic Trick 1187

Formula to Lookup Every 5th Item In a Column, INDEX and ROWS functions

DESCRIPTION

See how to create a formula to Lookup Every 5th Item In a Column using INDEX and ROWS functions.