Last seen: Jun 9, 2026
That's not really the point. All you need to do (here and in other forums) is add links to any cross-posts. Nobody is saying you can't do it.
Cross-posted here:
That was the formula to put in when adding a calculated column. The full code for the step would be: = Table.AddColumn(Source, "Fund", each Text.Tr...
I figured it was risky to assume the data would always have that space before the bracket. 😉 Real data is rarely that neat...
If the currency is always the last thing in brackets and you want everything prior to that, you can extract everything before the last delimiter with ...
As ong as you open the files in the desktop version, the VBA will work. If you have it open in the online version of excel (which is also what teams u...
I suspect you've unchecked the 'Default to full module view' option in Tools - Options - Editor tab, Window Settings section? Your second question ...
Perhaps something like this - just amend the D1# to whatever your spilled range should be: =LET(rng,D1#, numRows,SEQUENCE(ROWS(rng)), a,REDUCE("",n...
For the green count: =SUMPRODUCT(--(O13:s13/O$7:S$7>=0.75)) For the red (first): =SUMPRODUCT(--(O13:s13/O$7:S$<0.5)) For the balance...
If you can give an example of the criteria used for the conditional formatting, I will see what I can do.
No, what I'm suggesting is using a regular COUNTIF(S) function without any code. If you can apply the same criteria that are used to colour the cells,...
Are the cells coloured through conditional formatting, or do they have colours applied to them manually?
You can't use DisplayFormat in a function called from a cell. The easiest solution is usually to use something like COUNTIF(S) together with whatever ...
I suspect your UDF does something that is not allowed for a function called from a sheet. If you post the code, we can probably tell you what.
You're putting VBA code inside a formula string, which won't work. I don't really understand the second loop as you are returning the same value to ev...
