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
Jun 2024
9:25pm, 21 Jun 2024
75,711 posts
  • Quote
  • Pin
GlennR
Via a LinkedIn contact:

“ With the latest update in late May 2024, you may now be experiencing a bug with Microsoft Excel 365. This is a significant issue relating to inserting and deleting rows or columns in your workbook. We've seen that Excel can sometimes fail to insert or delete rows and columns but assume it has been done in dependent formulae. For example, cells linking to the range where you may try to insert a row shift their formulae as if the row was created, therefore linking to the wrong cell(s).
 
We have noticed this on our machines and those of many of our clients. It has to do with the latest build of Microsoft Excel and Microsoft is aware of and working on it. They suggest rolling back to an older version of Excel as per their response on a forum.”
Jun 2024
9:28pm, 21 Jun 2024
24,698 posts
  • Quote
  • Pin
larkim
That could be v nasty indeed if not spotted.
Jun 2024
11:32pm, 21 Jun 2024
17,202 posts
  • Quote
  • Pin
Badger
@Lost in Mud something to help you sleep soundly this weekend
3M
Jun 2024
7:58am, 24 Jun 2024
24,278 posts
  • Quote
  • Pin
3M
Eek! That could be quite nasty!

As long as it doesn't mess with my "days to retirement calculator" I think I'll probably cope. ;)
Jul 2024
3:09pm, 8 Jul 2024
25,033 posts
  • Quote
  • Pin
larkim
Not entirely found a use for it yet, but discovered the existence of the "let" function in Excel since 2020. Might help solve an issue for someone at some point.

support.microsoft.com

Feels more "programmy" so can see me using it at some point if i remember!!
JCB
Jul 2024
3:52pm, 8 Jul 2024
5,732 posts
  • Quote
  • Pin
JCB
Interesting. I don't think their examples are great at giving compelling reasons, but it could remove having a helper cell for the intermediate result (so I wonder if that would mean the speed with the helper cell would be similar to the Let)
Jul 2024
4:29pm, 8 Jul 2024
25,037 posts
  • Quote
  • Pin
larkim
I think it helps with nested ifs and that sort of thing, which are ugly and hard to decipher. Though of course there are better ways to do things with helper columns etc too.

I suspect the main benefit is making readable formula.

Now I know it exists I'll try to reverse engineer an opportunity to use it!
CBN
Jul 2024
5:43pm, 8 Jul 2024
118 posts
  • Quote
  • Pin
CBN
The most useful application of LET I have found is when used with FILTER, and for example an array generated with UNIQUE.

=LET(a, UNIQUE(A:A), FILTER(a,a<>0))
Jul 2024
10:08am, 10 Jul 2024
21,401 posts
  • Quote
  • Pin
Cerrertonia
Probably you've discussed this already - the Excel world championships, in Vegas?

theverge.com
Jul 2024
2:25pm, 11 Jul 2024
18,941 posts
  • Quote
  • Pin
JamieKai *chameleon*
Hiya, I have an Excel-Adjacent query and wondered if anyone could help (my usual go-to guy has had the audacity to take Annual Leave, and internet guides are baffling my tiny brain!)

I have a Power BI report taking an Excel Spreadsheet as its dataset. I'm wanting to update the report by replacing the spreadsheet with a new one (of the same name and general shape, just with different data). Is there anything special I need to do so that it updates? I've tried a practice spreadsheet and report (some nonsense about favourite colours, animals, etc) but I can't get it to do what I want!

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