This post will guide you how to repeat cell value N times in Excel. How do I copy cell value N times in Excel.
Repeat Cell Value N times
Assuming that you have a list of data that contain two column and one column is cell value that you want to repeat, and another column contain N number. To repeat cell value N times in Excel, just do the following steps:
#1 Insert a column to the left of A, so your current A and B columns are now B and C.
#2 Put 1 in A1
#3 Put =A1+C1 in A2 and drag the AutoFill Handle down to Cell A5.
#4 Put an empty string in B5, by just entering a single quote (‘) in the cell
#5 Put a number 1 in E1, a number 2 in E2, and copy down as to get 1, 2, …, 14
#6 Type the following formula based on the VLOOKUP function into the formula box of cell F1 and then drag the AutoFill Handle over other cells to apply this formula.
- Excel VLOOKUP function
The Excel VLOOKUP function lookup a value in the first column of the table and return the value in the same row based on index_num position.The syntax of the VLOOKUP function is as below:= VLOOKUP (lookup_value, table_array, column_index_num,[range_lookup])….