SpreadEveryone: The Fetchland Excel wire
1 lurker |
102 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 Jul 2025
-
Any pension experts out there? Oct 2024
Report This Content
You can report any content you believe to be unsafe. Please let me know why you believe this content is unsafe by choosing a category below.
Thank you for your report. The content will be assessed as soon as possible.