for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

101 watchers

um Jul 2022 9:04am, 6 Jul 2022 6,245 posts	0 um [ I spent more time wondering what variant Smell was, until it dawned on me, given the actual content ]
GregP Jul 2022 9:16am, 6 Jul 2022 136,798 posts	0 GregP
Diogenes Jul 2022 9:36pm, 6 Jul 2022 71,185 posts	0 Diogenes Each month I produce six lots of two different charts for various business units. After inserting each chart there is a certain amount of formatting of each one to do. After three or more years of doing this I finally got round to creating two templates to speed things up a bit. I knew about templates before, I just never remembered to create the before I moved on to the next chart.
run free Jul 2022 11:26pm, 6 Jul 2022 5,067 posts	0 run free You talking about chart templates or workbook templates or both?
Diogenes Jul 2022 11:42pm, 6 Jul 2022 71,191 posts	0 Diogenes Chart templates
run free Jul 2022 3:34pm, 7 Jul 2022 5,070 posts	0 run free A hidden feature. Nice 😀
Fitz Aug 2022 9:14am, 12 Aug 2022 2,840 posts	0 Fitz Here's one for the Excel superbrain hive mind. My table of data has 100+ columns and 9000+ rows. For each row: I need to know the first column that has a value in it. I need to know the number of subsequent columns that are empty. I need to know the average value of the non-empty cells (that bit is easy!) Because then I need to multiply the number of empty cells by the average of the non-empty cells. Thanks!
um Aug 2022 9:36am, 12 Aug 2022 6,384 posts	0 um Why do you need the first column Fitz? countblank(range) will give you the total number of embpty cells of countif(range,"<>") will give you the number of non empty cells Does that help, or am I missing something? If you do need the first column, this gives one option extendoffice.com
SPR Aug 2022 9:39am, 12 Aug 2022 37,911 posts	0 SPR Counta does non blank cells.
Fitz Aug 2022 10:17am, 12 Aug 2022 2,841 posts	0 Fitz Thanks um, it's because I'm only interested to the number of blank cells to the "right" of the first non-blank cell. So for example: If column B has a value, count the blanks from C:Z But if the first column with a value is col. K, count the blanks from L:Z And so on for each row.