excel - How to distinguish between two "stale values" and blanks in between two values in a column of data? -

-

i asked question linear interpolation of data missing values. here link question

what dynamic solution linear interpolation of data in row missing values indefinite number of missing value sequences?

a new problem has arisen pertains case blank sequence ends in blank, , not filled value. in case, formula repeats last filled value in latest blanks. want is, have way conditional formatting or adding 0.0000009 sort of number distinguish stale data.

below sample data:- (this data result of formula described solution provided)

date    data    updated data 1/1/2001    1   1.000000000 2/1/2001    2   2.000000000 3/1/2001    3   3.000000000 4/1/2001    4   4.000000000 5/1/2001        4.250000090 6/1/2001        4.500000090 7/1/2001        4.750000090 8/1/2001    5   5.000000000 9/1/2001    6   6.000000000 10/1/2001   7   7.000000000 11/1/2001       7.666670090 12/1/2001       8.333330090 1/1/2002    9   9.000000000 2/1/2002    11  11.000000000 3/1/2002        11.000000090 4/1/2002        11.000000090

how can distinguish between last 2 11s , normal data above? since data stale , technically not right data.?


Comments

Post a Comment

Popular posts from this blog

ios - MKAnnotationView layer is not of expected type: MKLayer -

-
Image
so code works fine logger riddled message. there way rid of or suppress it? postannotation.swift class postannotation: mkpointannotation { //mark: properties let post: post //mark: initialization init(post: post) { self.post = post super.init() self.coordinate = cllocationcoordinate2d(latitude: post.latitude, longitude: post.longitude) self.title = post.title self.subtitle = post.timestring() } } adding annotation let annotation = postannotation(post: post) self.map.addannotation(annotation) func mapview func mapview(_ mapview: mkmapview, viewfor annotation: mkannotation) -> mkannotationview? { if annotation mkuserlocation { return nil } var annotationview = mapview.dequeuereusableannotationview(withidentifier: "pin") as? mkpinannotationview if annotationview == nil { annotationview = mkpinannotationview(annotation: annotation, reuseidentifier: "pin")
Read more

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

unity3d - Unity SceneManager.LoadScene quits application -

-
i have 2 different scenes 1 named 'main' , other 'game' both added scenes in load. when use scenemanager.loadscene("game"); works no problem when tried return main scene code if (input.getkeydown (keycode.escape)) { scenemanager.loadscene("main"); } strangely game quits. thanks. sorry interruption. somewhere on other script found code. if (input.getkeydown (keycode.escape)) { application.quit (); } that's bad, know...
Read more