New Function released TRIMRANGE

https://techcommunity.microsoft.com/...s/ba-p/4230202

This is currently only available to insider Beta Version and was released on August 8, 2024

Thanks, I'm currently stuck on 2407 - despite being on the insider channel, it's telling me I'm up-to-date (I'm not - 2409 is the latest). Just got to wait until MS fix whatever is blocking my updates ...

@Ali
I had an issue two weeks ago. Contacted MS and they remoted in and fixed my issues. Since you are on 365, you probably have unlimited service help. It would be worth a try.

Mmm. Might look into that. My Surface has updated fine - my laptop won’t. I wonder if a rollout can be uninstalled?

@Ali: you'll just have to get by with TOROW(rng,1) and TOCOL(rng,1)

I do that all the time, Trevor.

I'm more concerned about being stuck on 2407 forever!!!

So, I reverted to the Insider Channel and ran updates - this got me to 2408. I have now switched back to the Beta Channel and updates are downloading, so I should be on 2409 fairly soon.

Now on 2409 - TRIMRANGE is not available (Build 18025.20006).

They must have removed it for some reason - maybe buggy?

Any idea how to get the IOS version updated on an iPad?

Missing quite a few things, highlighted by the absence of PIVOTBY and TRIMRANGE

I don't have an iPad, sorry. Do you also have the MS Office app installed? I needed that for the individual apps to properly recognose my OneDrive on my iPhone. No PIVOTBY, though.

I think I deleted it because I always just used individual apps. But I just reinstalled and it seems to have resolved an issue with a couple of files in One Drive that I couldn't get rid of. They weren't accessible on my laptop, but they still were visible on my iPad. Gone now. So thanks for that

No PIVOTBY or TRIMRANGE though

I'm on the 2410 rollout now - still no TRIMRANGE!

Interesting as I am on 2410 now and I have it.

The rollouts are nothing if not erratic. It took ages for GROUPBY and PIVOTBY to appear for me. I'm on 64-bit - that can slow things down (they deliver to 32-bit installations first, apparently).

It has been added here, though: https://bettersolutions.com/excel/fu...-functions.htm

I'm now on: Microsoft® Excel® for Microsoft 365 MSO (Version 2410 Build 16.0.18112.20000) 64-bit

Still don't have it ...