Forum Discussion
How to Use Existing Value in a Column to Predict when a Specific Value Will be Reached or Exceeded
I have no clue how to do that and my search fu has been weak (as it must be for an octogenarian).
Let's not go disparaging ourselves (I say as another octogenarian). We can still excel at using Excel. It may take a while, but if you did it once, you can re-learn.
It has been decades since I use Excel on a daily basis; so I have forgotten a lot that I once knew. I use it nowadays only for household tracking.
That's what I do too. Anything to keep me learning. And I answer questions now and then here on this forum, which has made it possible for me to discover some of the newer functions that didn't exist back in the day. I also rely on the many amazing functions rather than VBA and macros.
Anyway, may I suggest that you post a copy of that energy consumption spreadsheet on OneDrive or GoogleDrive, with a link pasted here that would grant us access? That way we could make specific suggestions in response to your question, responses tailored to the way you're doing your tracking.
As to resources that could help you re-learn Excel:
- ExcelJet is a very good on-line resource. You can spend hours there with their examples of essential functions.
- And YouTube has a wealth of videos for all levels of skill.' Here's a link to their beginners materials.