SpreadEveryone: The Fetchland Excel wire
88 watchers
6 Jul
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  ]
|
6 Jul
9:16am, 6 Jul 2022
136,798 posts
|
GregP
|
6 Jul
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. |
6 Jul
11:26pm, 6 Jul 2022
5,067 posts
|
run free
You talking about chart templates or workbook templates or both?
|
|
6 Jul
11:42pm, 6 Jul 2022
71,191 posts
|
Diogenes
Chart templates
|
|
7 Jul
3:34pm, 7 Jul 2022
5,070 posts
|
run free
A hidden feature. Nice 😀
|
12 Aug
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! |
|
12 Aug
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 |
12 Aug
9:39am, 12 Aug 2022
37,911 posts
|
SPR
Counta does non blank cells.
|
|
12 Aug
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. |
The Doctor K Cup
This year sees the fifth edition of our annual challenge in memory of the Fetchies who have sadly passed away. It's named after Doctor K, who died of pancreatic cancer in 2017
Are you doing the right training?
See typical mileage, pace and long run stats for every distance and goal. See a comparison with your own training.
Heart Rate Analysis
See your heart rate training data from the last 12 months broken down in technicolour.
Flat as a pancake?
We've collected thousands of your reviews from events, and worked out which races give you the best chance of a fast time!