I have a column with certain values and corresponding values in the next column. I want to be able to autopopulate a 4th column with the 3rd column equispaced, as shown in this figure. I only put 17 rows to get the message across, but I would eventually have until 36 in column "cr3." could you please help? Thanks
<tbody>
</tbody>
cr1 | cr2 | cr3 | populate |
0 | 1 | 0 | ? |
1 | 17 | 1 | ? |
2 | 17 | 2 | ? |
3 | 4 | 3 | |
4 | 9 | 4 | |
5 | 8 | 5 | |
6 | 7 | 6 | |
7 | 2 | 7 | |
8 | 1 | 8 | |
10 | 3 | 9 | |
11 | 1 | 10 | |
13 | 1 | 11 | |
14 | 1 | 12 | |
16 | 1 | 13 | |
18 | 1 | 14 | |
36 | 1 | 15 |
<tbody>
</tbody>