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,
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 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help