Forum

You should also note that if you cross-post to multiple forums, etiquette dictates that you provide all links in each forum so that people don't dupli...

Your first version of the formula didn't have the additional text argument after "Replen" that your second version does have. The second one shouldn't...

It can be done in Lists. A simple way is to create a calculated column that subtracts the review date from TODAY() (or vice versa) and then you can co...

A macro wouldn't be that complicated - though I suspect you might be able to get the result you need just using something like the camera tool - but i...

You could use: =LOOKUP(2,1/(B4:J4<>0),B$1:J$1)

The formula is basically: =LOOKUP(2,1/(Column1<=LookupDate)/(column2>=LookupDate),column3) where LookupDate is your lookup date, column 1 ...

That's either pure luck or they simply haven't reported it. Getting API calls wrong tends to lead to applications terminating without warning, and tho...

@Hans Most of those VBA7 declarations are wrong for 64 bit. All handles and pointers need to be LongPtr not Long. You can't just put PtrSafe into a...

And which version of Excel do you have?

AND and OR only return one result, not an array of results. so you would need to enter the correct formula into one cell and copy it down - eg =IF(...

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 ...