I have a spreadsheet with a column that is adding cumulative numbers such as below:
2,250
4,499
6,738
8,976
11,214
13,441
15,668
17,895
20,110
22,314
24,517
26,710
28,902
31,094
33,287
35,479
37,671
39,864
42,056
In another column I want to return a result of the number "1" for every increment to the nearest 7000
So ultimately I would like a "1" displayed against the numbers above of:
8976
22314
28902
35479
42056
Seeing as those are the numbers that are above the nearest 7000 increment.
If I only had a few numbers I would just plug it in but my numbers are going up to 600,000
Any help would be appreciated. I'm happy to try and nut it out if I can at least know what formula to start with.
Lu
Bookmarks