Hi ,
It looks like you're using an ad blocker.



The revenue generated from the adverts on the site is a critical part of our funding - and it's because of these ads that I can offer the site for free. But using the site for free AND blocking the ads doesn't feel like a great thing to do, which is why this box is so large and inconvenient. Some sites will completely block your access, but I'm not doing that - I'm appealing to your good nature instead. Did you know that you can allow ads for specific sites, whilst still blocking them on others?

Thanks,
Ian Williams aka Fetch
or for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

1 lurker | 102 watchers
um
Jul 2022
9:04am, 6 Jul 2022
6,245 posts
  • Quote
  • Pin
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
  • Quote
  • Pin
GregP
:)
Jul 2022
9:36pm, 6 Jul 2022
71,185 posts
  • Quote
  • Pin
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
  • Quote
  • Pin
run free
You talking about chart templates or workbook templates or both?
Jul 2022
11:42pm, 6 Jul 2022
71,191 posts
  • Quote
  • Pin
Diogenes
Chart templates
Jul 2022
3:34pm, 7 Jul 2022
5,070 posts
  • Quote
  • Pin
run free
A hidden feature. Nice 😀
Aug 2022
9:14am, 12 Aug 2022
2,840 posts
  • Quote
  • Pin
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
  • Quote
  • Pin
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
  • Quote
  • Pin
SPR
Counta does non blank cells.
Aug 2022
10:17am, 12 Aug 2022
2,841 posts
  • Quote
  • Pin
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...
  • Show full description...

Related Threads

  • excel
  • support
  • tech
  • work

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.










Back To Top

Tag A User

To tag a user, start typing their name here:
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 114,483 Fetchies!
Already a Fetchie? Sign in here