SpreadEveryone: The Fetchland Excel wire

88 watchers
um
6 Jul
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 ;-) ]
6 Jul
9:16am, 6 Jul 2022
136,798 posts
  •  
  • 0
GregP
:)
6 Jul
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.
6 Jul
11:26pm, 6 Jul 2022
5,067 posts
  •  
  • 0
run free
You talking about chart templates or workbook templates or both?
6 Jul
11:42pm, 6 Jul 2022
71,191 posts
  •  
  • 0
Diogenes
Chart templates
7 Jul
3:34pm, 7 Jul 2022
5,070 posts
  •  
  • 0
run free
A hidden feature. Nice 😀
12 Aug
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
12 Aug
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
12 Aug
9:39am, 12 Aug 2022
37,911 posts
  •  
  • 0
SPR
Counta does non blank cells.
12 Aug
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.

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...

Related Threads

  • excel
  • support
  • tech
  • work

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!


Back To Top
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 109,086 Fetchies!
Already a Fetchie? Sign in here