| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula for copying data for every 8th cell
Hello,
I am looking for a formula that will allow me to copy either text or numerical data in sequence for every 8th cell. The problem that I have is that excel uses the relative/absolute reference and copies cells in sequence. Example: A1:A20=1-20 B1=1,B2="",B3=""....B8=2,B9="",B10="",B16=3 A1=1 B1=1 A2=2 B2=€€ A3=3€¦.. B3=€€€¦ A20=20 B8=2 B9=€€ B10=€€€¦ B16=3 Thank You, Judd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Cell contents vs. Formula contents | Excel Discussion (Misc queries) | |||
| Aligning Two Lists in Excel | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
