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

102 watchers
Jan 2024
5:29pm, 16 Jan 2024
49,171 posts
  • Quote
  • Pin
HappyG(rrr)
In C++ and Pascal it was + for concatenating strings. Makes more sense. No, didn't know &.

Harmless
Mostly Harmless
Novice
Competent
Expert
Master
Dangerous
Deadly
Elite

I thought I was 4, but might only be 2? :-) G
Jan 2024
5:51pm, 16 Jan 2024
18,230 posts
  • Quote
  • Pin
JamieKai *chameleon*
Ah, that takes me back!
Jan 2024
6:11pm, 16 Jan 2024
150,214 posts
  • Quote
  • Pin
GregP
C++ ?

Lovely that we get kids on this wire :)
Jan 2024
6:30pm, 16 Jan 2024
18,231 posts
  • Quote
  • Pin
JamieKai *chameleon*
(I was referring to the Elite classification list - not seen that in some 30 years)
Jan 2024
6:32pm, 16 Jan 2024
150,215 posts
  • Quote
  • Pin
GregP
you can add with it too.

=a1+(a3=a4)
Jan 2024
6:37pm, 16 Jan 2024
23,000 posts
  • Quote
  • Pin
larkim
Multiply would work too I guess, almost as an if statement?

=A2*(A3=A4)
Jan 2024
11:04am, 24 Jan 2024
150,360 posts
  • Quote
  • Pin
GregP
PowerBI hates me. Or MS Lists does. Or both.

For reasons passing all understanding pretty much everything that would logically be in Excel has moved to MS Lists. Exporting to PowerBI in an attempt to garner some sort of reporting capability is thwarted by only a seemingly random subset of columns being included in the exported dataset.
Jan 2024
11:38am, 24 Jan 2024
74,208 posts
  • Quote
  • Pin
GlennR
Now I'm going to have to find out what MS Lists is.
Jan 2024
11:40am, 24 Jan 2024
74,209 posts
  • Quote
  • Pin
GlennR
Oh, I have no use for that. Back to my Excel model...
3M
Jan 2024
12:30pm, 24 Jan 2024
23,161 posts
  • Quote
  • Pin
3M
I'm being funnelled down a route of PowerAutomate and PowerApps at work, in order to "get the best out of 365". :-o

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,286 Fetchies!
Already a Fetchie? Sign in here