excel - Grouping records whle filling gaps with zero -

- 

1    2280   3    1250   5    1245   9    1258

but need result this:

1 2280   2 0   3 1250   4 0   5 1245   6 0   7 0   8 0   9 1258   10 0

may formula easier. 

=iferror(vlookup(d1,$a$1:$b$10,2,false),0)

enter image description here


Comments

Post a Comment

Popular posts from this blog

how to insert data php javascript mysql with multiple array session 2 -

-
i have method method discussed , successful data entered 1 when more 1 can not database this programs my php form : <form class="form-horizontal" id="form-produk"> <div class="control-group" > <label class="control-label" for="kelas">kategori</label> <div class="controls"> <select class='form-control' name='id_kategori'> <?php $tampil=mysql_query("select * kategori order nama_kategori"); if ($id_kat==0){ echo "<option value=0 selected>- pilih kategori -</option>"; } while($w=mysql_fetch_array($tampil)){ if ($id_kat==$w[id_kategori]){ echo "<option value=$w[id_kategori] selected>$w[nama_kategori]</option>"; } else{ echo "<option value=$w[id_kategori]>$...
Read more

c++ - How to test/verify that zero-initialization takes place -

-
i trying test 0 initialization on virtual machine g++ options -std=c++98, -std=c++03, -std=c++11 unfortunately there not many garbage values , see zeros in place shouldn't be. how force random values can test this? #include <iostream> #include <string> using namespace std; class { public: int a; }; class b { public: b(){} int x; }; int main() { { int tab[50000] = {0}; } a; a* aa = new a; b b; b* bb = new b; cout << a.a << endl; cout << aa->a << endl; cout << b.x << endl; cout << bb->x << endl; return 0; } you not guaranteed see random numbers. c/c++ standard says uninitialized values undefined, cannot values have. 0 ok (maybe virual machine zeros memory before allocating). if need random numbers, generate them using <random>
Read more

node.js - Webpack/TypeScript Raising Errors When node_modules is Excluded -

-
Image
i have following webpack , typescript configs: webpack.config.js module.exports = { entry: { dev: './src/ts/site' }, output: { filename: './com/js/site.js' }, resolve: { extensions: ['', '.ts', '.tsx'] }, module: { loaders: [ // typescript { test: /\.tsx?$/, loader: 'ts-loader' } ] } } tsconfig.json { "compileroptions": { "noimplicitany": true, "module": "commonjs" } } i've simplified project include following dependencies: package.json (partial) "typescript": "^1.7.5", "ts-loader": "^0.7.2", "webpack": "^1.12.9" when run webpack, massive slew of errors: the list goes on many many screen lengths, far i've scrolled every 1 duplicate identifier err...
Read more