Referencing every nth cell in a new column
I have data in E4, E12, E20... that I want to copy into a new column without
the extra rows in between. How can I do this?
So far I've tried entering =E4 in the first cell, then =E12, and then using
the fill handle. Didn't work :( I'm not very good at excel so please be
specific if you talk about coding or heavy duty formulas.
|