Records re-allocation problem.

[Dawn]

Dear all,
There’s a table A in a sheet in excel, in this table ,the records are
placed row byrow,for example,if there are 20 records,then it occupies 1-21
rows(including column heading.)
And I have to use the records in another table B,but the pattern of table B
is for every four rows ,the first equals the one row in table A,and the other
three rows are kept null,for example,(the second row in table B= the second
row in table A;the sixth row in table B= the third row in table A;the tenth
row in table B= the forth row in table A;…etc)
How can I relize it?Thanks.
Best regards.
Dawn Wu
Shanghai,China

 

[Stefi]

=INDIRECT("TableA!"&ADDRESS(FLOOR(ROW()/4,1)+IF(ROW()=1,1,2),1,4,1))
returns the required row of column A
=INDIRECT("TableA!"&ADDRESS(FLOOR(ROW()/4,1)+IF(ROW()=1,1,2),2,4,1))
of column B, etc.

Regards,
Stefi

„Dawn†ezt írta: