excel - Formula to compare a set of cells and return value -


my formula is

{=iferror(if(max(if(n17:$n$32="d",row(n17:$n$32)))=  min(if(isblank(e17:$e$32),row(e17:$e$32)))-e17,"d",""),"")}

basically, rows delegated 2 different types: parent , child.

the type shifts if variable changes in cell. formula's purpose identify how many rows below still child rows, , (with d being placed in next cell) determine if child complete. if children below parent row complete, current cell should return value "d".

this formula work... able identify if last cell of children complete. not check children between , parent have data put in or not.

to answer question, changed angle of attack , have made formula:

{=if(isblank(c7),"",if(countif(n8:indirect("n"&min(if(isblank(n8:$n$98),row(n8:$n$98)))),"d")=counta(e8:indirect("e"&min(if(e8:$e$98=0,row(e8:$e$98)-1)))),"d",""))}

rather assigning value cell, instead decides whether cell true or false , counts base on number of true's. allow me retain variable length assign "d"one if cells in question have "d" in them.


Comments

Post a Comment

Popular posts from this blog

javascript - Confirm a form & display message if form is valid with JQuery -

i'm developing django application , use javascript in order improve website. i have form , display 2 things : confirm form before submit if form submitted, display message : 'form saved' it's first time i'm using js , need make process. this code : <form class = "form" method='post' action=''> {% csrf_token %} <br></br> {{ form.as_p}} <br></br> <button type="submit">valider</button> </form> <script> $('#form').submit(function() { var c = confirm("click ok continue?"); return c; //you can return c because true or false }); </script> and if form valid , saved : <script type="text/javascript" > $(document).on('valider', 'form.form', function(form) { var $form = $(form); $.ajax({ ...
Read more

Retrieving ETA (estimated time of arrival) with Google Distance Matrix API and public transit as transport mode -

Image
is possible retrieve eta google's distancematrix api (or alternative api). fyi, eta different duration, when using public transport. following example clarify request. when leave on friday @ 8.15 i'll able catch train @ 8.30 , arrive @ 9.00 am. google says duration 30 minutes. however, when leave on saturday @ 8.15 i'll able catch first train @ 9.00 , arrive @ 9.30 am. google still says duration 30 minutes, means ignore delay. google map supports functionality there api around giving me eta instead of duration. can see, distance-matrix' response no good. clarifying question little. eta estimated time of arrival , it's clear user wants know entire duration of transport (including waiting time public transport).
Read more

ionic framework - Meteor - Error: Failed to execute 'insertBefore' on 'Node' -

i trying make dynamic list display using meteor, idea load more elements each time bottom of page reached. the html template following : <template name="contacts"> {{#contentfor "headertitle"}} <div class="bar bar-header bar-assertive"> <h1 class="title">contacts :</h1> </div> {{/contentfor}} {{#ionview}} {{#ioncontent}} <div class="list"> {{#each contacts}} <a class="item item-avatar" href="/contacts/{{_id}}"> <img src="/img/ico_client.png"> <h2>{{full_name}}</h2> <p>{{company}}</p> </a> {{/each}} </div> {{#if moreresults}} <div id="showmoreresults" style="margin-left: 25px;"> <span class="loading">loading...</span> </div> {{/if}} {{/ioncontent}} {{/ionview}} </te...
Read more