Enter this formula in A1 and copy down...
=INDEX(B:B,ROW($B$7)+5*(ROW()-1))
or
copy down until you get blanks...
=IF(ROWS(A1:A$1)<=COUNTA(B:B),INDEX(B:B,ROW($B$7)+5*(ROW()-1)),"")
Enter this formula in A1 and copy down...
=INDEX(B:B,ROW($B$7)+5*(ROW()-1))
or
copy down until you get blanks...
=IF(ROWS(A1:A$1)<=COUNTA(B:B),INDEX(B:B,ROW($B$7)+5*(ROW()-1)),"")
Last edited by jeffreybrown; 12-13-2011 at 02:18 PM.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks