Hi,


Column A has dates 365 per year. B has meter readings (sporadic), C has days between readings, D has gas used between readings, E has gas per day.

So as to make the calculation of C and D and E easy, with formula referring to the cell above, so copy paste repeatable down the entire column, I opted to filter rows in B with 0 in it then delete those rows.
Col A will be the X axis in a graph BUT I want the X axis to feature 365 days, with the rows populating the appropriate date on that axis, with gas used per day for the Y axis is this possible ?

Otherwise can I somehow filter out the rows with 0 in for B, so that I can do that formula act as planned, referring to the row above that does have a figure to work on, something like filter find row with 0 in B column, then hide row and exclude row from being seen by formula ?

DBenz

Maybe you should consider answering responses to questions you posted earlier (such as: auto progress number evenly between two values across empty cells).

Of course it is possible that you can't use the proposed solution but if so, what about telling why to whoever tried to help you?

Hi, I looked in on Excel and replies, didnt see any on those I looked at, but overlooked the time progression one by mistake. I see one still has none, and looking again now there is one that happened last night whilst we in the UK are in bed, and hadnt after that, got round to all of them again due to being pulled away, so sorry I didnt get to answer yours in my normal timeframe, probably not the only one to not revisit a post within 4 days though.
I do normally look at posts then post new, in that order, but sometimes I post first whilst problem fresh in my mind as replying to posts can lose train of thought.

Sorry you've lost me there, my two ideas here are not possible you say, I am to tell why that is to the person who tried to help me with them here, but I havent see anyone with help in this thread on this yet ?
Not sure how one tells someone why their own ideas are not possible anyway.

DBenz