Hi,
How can I repeat the formula in cell above a number of times?
For Example in the above cell I have 5 therefore I need to do this repeat formula 5-1 times.
Note:- I want to repeat the formula from the cell above to the cells below in a row a number of times. The number of times the formula has to be repeated will come from another cell.
Thanks
assuming D1 is the number of times you want to repeat and F is your output column
Formula:
Please Login or Register to view this content.
replace a1*b1 with the formula you want
Last edited by humdingaling; 07-17-2015 at 02:59 AM. Reason: attached workbook
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks