Awesome

I’ve watched a few videos on inserting scroll bars, but this is the first one I’ve been able to follow. Well done.

You know what, i have been addicted to your videos. You are doing great job and i keep growing myself thanks to your instructional videos. Warm regards

Super 👍

Only been waiting 30 years for this! Will Excel REGEX support positive/negative look behind/ahead?

Thank you. I love your VDOs.🌹

Is possible to use Regextract to extract date from a string of text ?

Hi, thank you for all your help! I have a problem that's driving me crazy. When I use measures in pivot tables I see the entire dataset once I double click to get the summaries. I end up doing groups in power query which result in my reports being huge… Is there a way to limit the summaries in pivot tables to what the measure is designed for vs the entire table???

Super

I don't understand, is there a benefit in performance if I made the changes in the Transform file?

Looks great Mynda - probably not much use to me but good to know when/if the time comes! Thanks - I love learning new things even if no use to me!

In the Customers table, shouldn't the dimension be "Customer ID"? To match exactly with the key in the first table of your model?

Hi Mynda, I found this video very helpful, and actually made me work differently. But I have discovered a problem. I am using your example but is there a way to pass the folder name and path in as a parameter? Any help would be appreciated as it is driving me mad.

Not got it yet 😪 but it should be useful and could hopefully save using PQ on occasion. Much as I am a PQ fan, and Pivot Tables for that matter, I find the need to refresh more and more annoying.

PQ has definitely changed how I work. But when something in the new table doesn't jibe with the previous table, then the hunt begins to correct the code or to redo the whole query. 😢 The data sets I get are for 4 states. Each state has their own analyst who created the source data, so sometimes headers are inconsistent or has extra spaces. 🙄 Once i get a partially scrubbed data set, then i need to hunt for IDs that have more than 10 unique addresses. Since sometimes the address is ST vs Street AND the requirement is no more than 10 addresses per ID, it requires me to hunt them all down visually with some added formulas. All that to say, you got me part way there. And for that, im grateful. Is it wishful thinking to learn that i might be able to use PQ for a final report?

this function is not available on my office. I hope this function can be updated in the office soon.

Hi Mynda , I thank God for people like you, thanks very much for your contents , God bless you always !

I won't have to import resources and write functions to get regex in Excel sheets? Oh, good news!

I hope once this get released ChatGPT can take an example string and provide the characters needed.

Amazing how people that call themselves data experts have never heard of RE...Where have they been since the late 1970's...?

30 years to late and the syntax makes absolutely no sense. A RE is an RE and is very well defined outside this "new" MS context. I'll stick with Sheets which follows well established standard;-)

I tried to enter formula =COUNTA(A19#). It showed me value of zero.

Awesome

Nice, thanks! Mynda, I couldn't watch the whole video since it gave an error on Mac that It will not work properly on Mac. My question to you is how to take out Total of Running Total? I have created my Pivot Table and got the Running Total but now at the end, I want it to show Total of Running Total? Thanks

thank you:)

Legend!! As an individual with ADHD, you had my focus and kept my focus! i really appreciate you and all your efforts!:)

Sounds like you need a travel router. I don’t roll anywhere out of town without mine. I also connect my Firewalla to it so not only do snoopers have to get past the routers firewall they also have to get by my Firewalla box.

SWITCHed recently on Beta channel I have them

Mynda, how would you do if you have very messy data and then you have data in blocks? All blocks differ in their size. Some have 2 Values and the rest are empty. Some have no value. Many Sellers have been combined in one sheet. Months are horizontally for the whole year so that is a monthly report. What would be the best approach for finding the Cumulative Value for Qty and Am in this scenario when all cells don't have values? Thanks

This would be cool if REGEXREPLACE would have LAMBDA function for further replacement logic. The MatchEvaluator delegate in .NET does this job. The pseudo function would look like this: =REGEXREPLACE("This is regex 123 and 456", "[1-3]+", LAMBDA(match, LET(m, --match, IF(m=123, m*2, m*3)))) So, when regex finds "123" string, it passes it to lambda, which processes this matched value the way it's required. In this case, if match is equal to 123, then it's double, otherwise it's tripled.

Can you place formulas WITHIN the regex pattern? Also, can the regex pattern handle references to arrays?

Got so excited only to realise that I am not one of the chosen few!

Are there any platforms out there that are entirely dedicated to stalk analysis and stock investment portfolio tracker??

It's about time that Excel added this. Thanks for another crystal clear explanation.

there is a competitor Excel channel i also watch who dropped a similar video but i much prefer Mynda's

I believe, the identifier part (before the @) of an email address may also include the underscore (_) and tilde (~) characters so I guess they also need to be inserted in the regex, shouldn't they?

Turns out you cannot do this to a table that's been set up via DAX, because for some reason you can only see imported tables in Power Query. You can add columns, but I cannot work out how to manual add in the sort numbers, it just doesn't allow it. My issue is, I've set up a bridge table for regions using DAX, so I could have a slicer to filter between North / Midlands / South. However, I can only have them appearing in alphabetical order A-Z or Z-A. Does anybody know a way I can add a sort column into such a table or do I need to create the table in excel, import in and redo all the region relationships with the new table? P.S. I've never known a program as bad as this before, in terms of overcomplicating the simplest of things. This is happening with almost everything and it's so tiring!

I frequently use Google Sheets just for the built-in regex functions, which were not previously available in Excel. Here's an idea for an easy project to learn: clean up the formatting of a list of phone numbers. First, convert any phone numbers in your list that are treated as numbers to text, since regex only works on text. Then use regexreplace to remove any characters that are not numbers (replace "\D" with nothing). Then use regexreplace to insert hyphens, if that is the formatting you want: in regexreplace, capture "(\d{3})(\d{3})(\d{4})" and replace with "$1-$2-$3" ($1 equals the first captured group in parentheses, $2 the second and so on), assuming Excel uses the $ format for captured items. Finally, you could use Filter to create an error report for any results that do not match the expression "\d{3}-\d{3}-\d{4}", which in Filter might be formatted as not(regexmatch(...).

this is the formula that i sometimes use gg sheet then excel. goodjob MS

I am so glad to see REGEX in excel! Thank you for the video.

Finally!

Sadly, they don't appear in functions list... 😪 (Version 2406 Build 16.0.17716.20002). EDIT: On another computer they DO appear!

Thanks Mynda.⭐I can certainly see a big use case in data cleanup and data extraction of large datasets.

I am using MS 365 - Beta Channel - Version 2406 -(Build 17716.20002) but this function is not available. Why?

Regex? Really? This is cool! ))) So, does it support non-backtracking, balancing groups, groups naming, options for modifying behavior on the way of the text? ))

This is fantastic, thanks. Now just need it in Power Query!

Nice. I am training on agile PM, so this fits. Best exercise is to follow your video and create from scratch. Thanks

Nice thanks

WOW! This is so new, I’m still downloading the update… But, still, WOW! Very powerful, indeed. OK, caveat: now I need to learn about REGEX. Thanks for this Breaking News, Mynda! :-)

I don’t need/use the full power/capabilities of Excel at work, we just use as a basic base. But I do play around with Excel at home. I can see me using this once it’s available. I’ve only ever heard of REGEX but never actually seen it used, I’m looking forward to learning this.😀