You could use this formula:
=INDEX(Sheet1!A:A,ROWS(A$1:A1)*4-3)
Copy down as needed.
You could use this formula:
=INDEX(Sheet1!A:A,ROWS(A$1:A1)*4-3)
Copy down as needed.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks