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: Expec...
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.