SpreadEveryone: The Fetchland Excel wire

1 lurker | 101 watchers

SPR Jul 2019 12:22pm, 25 Jul 2019 28,754 posts	0 SPR That's a great tip Neal! Didn't even know about this existed! My fudge was always to pick a central cell for text and centre that. After googling I see it's now centre across selection in format cells.
Diogenes Jul 2019 12:37pm, 25 Jul 2019 38,816 posts	0 Diogenes That's my question answered too
GregP Jul 2019 12:39pm, 25 Jul 2019 113,543 posts	0 GregP What SpR said. Thanks
larkim Jul 2019 1:09pm, 25 Jul 2019 8,207 posts	0 larkim Wow, never knew that existed! I was going to point out that in some cases a nicely presented spreadsheet benefits all, so merged cells have some use, but that was before I knew about Neal's tip there! 25 years of using Excel and I'd never noticed that before!
GregP Jul 2019 1:11pm, 25 Jul 2019 113,545 posts	0 GregP +1
Badger Jul 2019 1:40pm, 25 Jul 2019 11,115 posts	0 Badger Ditto!
JCB Jul 2019 3:17pm, 25 Jul 2019 592 posts	0 JCB +3
flanker Jul 2019 5:12pm, 25 Jul 2019 18,438 posts	0 flanker Nor me
flanker Jul 2019 12:07am, 26 Jul 2019 18,441 posts	0 flanker ring any bells? xkcd.com
larkim Jul 2019 5:00pm, 31 Jul 2019 8,256 posts	0 larkim I have a number of data points (electricity usage) captured sporadically over a number of years with varying numbers of days in between. As usage is inconsistent between summer / winter etc, getting the spreadsheet to give me a realistic annual usage by extrapolating from each reading is unhelpful. What I'd ideally like is some form of dynamic formula which sums only those cells where the dates of entry ensure I'm summing at least 365 days of data. e.g. Date - Cum.usage - Period usage 1/1/2010 - 220 - 220 1/5/2010 - 350 - 150 1/7//2010 - 450 - 100 1/8/2010 - 500 - 50 1/11/2010 - 600 - 100 1/2/2011 - 900 - 300 1/6/2011 - 1000 - 100 I'd want at 1/6/2011 to be summing 100+300+100+50+100+150 because 1/6/2011 to 1/5/2010 is > 365 days, but 1/6/2011 to 1/7/2010 is < 365 days. I'm sure there must be a way of doing this, but I'm scratching my head!