| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
Thanks a ton! very informative and helpful.
"Gary''s Student" wrote: In E1 enter: =INDIRECT("A" &4* ROW()-2) and copy down -- Gary''s Student - gsnu200901 "Confusicous" wrote: I have a list of names in Column A and the names appear every 4 lines down. A2, A6, A10... In column E I just want the names to appear and this has 6,000 lines on the spreadsheet. Can anyone tell me the easiest way to get this to work out. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
