excel - I am trying to find a formula where the outcome can add or subtract a value from a row number. -

-

i trying find formula outcome can add or subtract value row number. e.g.

the formula looking should (imaginary) =cel(d(5+1), refers cel c6 instead of c5, +1 or -1 should outcome of formula or in separate cel, can refer or in formula itself.

does have solution?

rene

one way using index function, formula give nth cell in column c

=index(c:c,n)

so can derive n formula or include row number, e.g.

=index(c:c,row()+1)


Comments

Post a Comment

Popular posts from this blog

javascript - IndexedDB error: Uncaught DataCloneError: Failed to execute 'put' on 'IDBObjectStore': An object could not be cloned -

-
i using google maps api along html 5 geolocation api display position marker on map. once marker displayed have simple on marker double click function saves new marker current position using indexeddb. goes until object stored, recieve message " uncaught datacloneerror: failed execute 'put' on 'idbobjectstore': object not cloned. " in console. code follows: function initialize() { var mapproperties = { // set maps properties center:new google.maps.latlng(55.8580,-4.2590), zoom:8, maptypeid:google.maps.maptypeid.roadmap }; var map=new google.maps.map(document.getelementbyid("map-overview"),mapproperties); //display map in map-overview div function nogeolocation(e) { //a function handle users not have geolocation if (e) { var content = 'error: unfortunately geolocation service failed.'; } else { ...
Read more

amazon web services - When using Cognito credentials with AWS in a browser (javascript), keep getting "missing credentials" error -

-
Image
i'm attempting upload file s3 bucket of mine web browser using aws' javascript sdk. code looks this: aws.config.credentials = new aws.cognitoidentitycredentials({ accountid: 'dfhgdh', identitypoolid: 'fdagsd', rolearn: 'fdafds' }); var bucket = new aws.s3({params: {bucket: 'test-bucket'}}); var pdfupload = document.getelementbyid('pdf-uploads').files[0]; var params = {key: pdfupload.name, contenttype: pdfupload.type, body: pdfupload}; bucket.putobject(params, function (error, data) { if (error) { console.log(error); } else { console.log(data); } }); however, whenever reaches putobject command, keep getting error aws: "error: missing credentials in config {message: "missing credentials in config", code: "credentialserror"..." i'm sure i'm missing simple , stupid here, can't figure out life of me. (i different error when try hardcode bogus secret...
Read more

c# - How to set the datatextfield value instead of the value on a drop down list? -

-
i have list of countries, returns id , name. have string. drop down sets value id, @ point don't have id's. want able set selectedvalue text field. there way this? or there way compare string against list work out id? string country = "australia"; ddlcountry.datasource = listofcountries; ddlcountry.datatextfield = "value"; ddlcountry.datavaluefield = "key"; ddlcountry.databind(); ddlcounty.selectedvalue = ??? thanks ddlcountry.items.findbytext(country).selected = true
Read more