Last seen: Apr 29, 2025
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...
Is this the kind of thing you wanted?
It might also be useful to know your regional settings in case it's an issue with the decimal point.
You'd need to have two other queries that reference the first query, and add any additional steps in the other queries.
It's much harder to try and diagnose potential issues with code that you can't see... 😉 Especially as you haven't said what is actually happening. Ar...