Hi!
I have an excel sheet with 1048567 rows of data entries. I need help in pasting the formula to the entire sheet. I have entered my formula for the first row. Now I want to paste the same formula for every 6th row from the first row, in-between rows are left blank. If i manually paste the formulas for every 6th row, I would go mad. So, Please suggest me a solution to this. I attached the sample image of the spreadsheet and it explains what exactly i want.
Excel.png
Any help is very much appreciated!!
Thanks!
Bookmarks