Create a new column in column D that contains every 8th record in column B start

Question

Create a new column in column D that contains every 8th record in column B starting at row 4 (i. e. row 4, 12, 20, etc.). Looking for help in excel using the Vlookup function.

Data -4.499 -44.831 16.908 68.531 51.74 92.625 41.523 -13.306 77.414 18.424 86.25 83.265 -4.046 59.665 76.34 -40.756 -14.967 91.771 10.681 -27.121 23.688 42.18 25.061 71.455 4.171 76.272 -47.064 51.072 88.414 85.935 -23.319 75.513 53.806 2.666 -17.216 -6.328 42.533 37.702 53.519 -35.753 92.897 37.557 31.807 63.823 18.273 -15.246 76.243 63.611 -36.506 57.003 -49.171 69.245 14.952 1.906 -33.175 24.141 76.924 -14.589 52.73 -13.987 -1.644 -6.798 21.447 -20.306 -8.759 31.241 -26.415 68.385 87.493 39.156 17.317 90.527 -36.142 88.529

Explanation / Answer

Creation of a new column in column D that contains every 8th record in column B starting at row 4 :

This will create a new column D, which will have value from 4th row of column B to 1000th row of column B and (ROW()-2)*8+8 shows the every 8th record in the column B.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.