SpreadEveryone: The Fetchland Excel wire
98 watchers
Jul 2022
9:04am, 6 Jul 2022
6,245 posts
|
um
[ I spent more time wondering what variant Smell was, until it dawned on me, given the actual content  ]
|
Jul 2022
9:16am, 6 Jul 2022
136,798 posts
|
GregP
|
Jul 2022
9:36pm, 6 Jul 2022
71,185 posts
|
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. |
Jul 2022
11:26pm, 6 Jul 2022
5,067 posts
|
run free
You talking about chart templates or workbook templates or both?
|
|
Jul 2022
11:42pm, 6 Jul 2022
71,191 posts
|
Diogenes
Chart templates
|
|
Jul 2022
3:34pm, 7 Jul 2022
5,070 posts
|
run free
A hidden feature. Nice 😀
|
Aug 2022
9:14am, 12 Aug 2022
2,840 posts
|
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! |
|
Aug 2022
9:36am, 12 Aug 2022
6,384 posts
|
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 |
Aug 2022
9:39am, 12 Aug 2022
37,911 posts
|
SPR
Counta does non blank cells.
|
|
Aug 2022
10:17am, 12 Aug 2022
2,841 posts
|
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. |
Related Threads
-
Excel skills test
Mar 2019
-
Accounting Question
Oct 2017
-
Important excel files deleted - Please Help
Oct 2016
-
download training log to excel
Jan 2024
-
Excel boffins - your needed!
Sep 2018
-
World Cup sweepstake in excel
May 2018
-
HELP! Excel file corrupted and I need it!
Aug 2016
-
Running Club Spreadsheet to track PBs
Apr 2014
-
The Retirement Thread
Apr 2024
-
What do/would you miss about your job?
Feb 2024
