Forum Discussion
In need of advanced filling in Excel
I want to repeat this row to the lower rows, so the Table 1 should be like Table 2, but not as expected.
Table 1: Initial State
| (1) Top 5 .... |
| (2) Top 5 .... |
Table 2: Expected Results
| (1) Top 5 .... |
| (2) Top 5 .... |
(3) Top 5 .... |
| (4) Top 5 .... |
(5) Top 5 .... |
Table 3: Not As Expected
| (1) Top 5 .... |
| (2) Top 5 .... |
| (1) Top 5 .... |
| (2) Top 5 .... |
| (1) Top 5 .... |
If you have Microsoft 365 or Office 2021:
Enter this formula in a cell:
="("&SEQUENCE(5)&") Top 5 …"
It will automatically spill to 5 cells.
If you have an older version:
Let's say the first cell is A2.
Enter the following formula in this cell:
="("&ROW(A2)-ROW(A$2)+1&") Top 5 ..."
Fill down.
If the first cell is in another row, simply change the row number in the formula.
