Microsoft Office Tutorials and References
In Depth Information
Figure 16-18: Headers that are used to convert the vertical data into rows.
And now, the formula, which goes in cell D2:
=OFFSET($A$1,$C2+D$1-2,0)
Copy this formula across to the next two columns, and down to the next six rows. The result is shown in Figure
16-19.
Search JabSto ::




Custom Search