for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

SPR Jul 2019 12:22pm, 25 Jul 2019 28,754 posts	Quote Pin 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	Quote Pin Diogenes That's my question answered too
GregP Jul 2019 12:39pm, 25 Jul 2019 113,543 posts	Quote Pin GregP What SpR said. Thanks
larkim Jul 2019 1:09pm, 25 Jul 2019 8,207 posts	Quote Pin 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	Quote Pin GregP +1
Badger Jul 2019 1:40pm, 25 Jul 2019 11,115 posts	Quote Pin Badger Ditto!
JCB Jul 2019 3:17pm, 25 Jul 2019 592 posts	Quote Pin JCB +3
flanker Jul 2019 5:12pm, 25 Jul 2019 18,438 posts	Quote Pin flanker Nor me
flanker Jul 2019 12:07am, 26 Jul 2019 18,441 posts	Quote Pin flanker ring any bells? xkcd.com
larkim Jul 2019 5:00pm, 31 Jul 2019 8,256 posts	Quote Pin 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!