Current location - Education and Training Encyclopedia - Resume - How Excel Automatically Generate Summary Table by Using Personal Registration Form
How Excel Automatically Generate Summary Table by Using Personal Registration Form
If the table format is consistent and arranged regularly from top to bottom, you can use formulas to get numbers from it and form a summary table.

As shown in the figure:

Formula: =INDEX(A:A, (ROW()- 1)*6-5)

By adjusting the values inside, you can refer to different rows and columns.

Note: You can enlarge the picture by opening it on a new web page.