@MatthiasFriedmann

Ready for another challenge with List.Max and List.Min? 
Explore how to use them to quickly select the best and worst entries from a table: https://www.youtube.com/watch?v=D0C1FBn5bBY

@MatthiasFriedmann

If you wonder about the unusual vowel order, that is the order of the vowels in the Japanese kana　あ、い、う、え、お.
👉Initially that was without intention, but it nicely demonstrates the advantage of using List.Max❗

@MatthiasFriedmann

Did you wonder how this sweet little kitty made its way into this video? 😺
In the original challenge an incredulous reader shared 'kitty and I have both been staring at that one for a while'. 
=> In this video, I dive deep into the solution to explain to our curious kitty how and why it works.

@MatthiasFriedmann

Here is the code created in the video:
let
  Source = Excel.CurrentWorkbook(){[Name="VowelReplacement"]}[Content],
  Transform = Table.TransformColumns(Source, {{"String", each 
      Text.Combine(
          List.Transform(
              Text.ToList(_),
              (x)=> List.Max(List.Select({"A","i","U","e","O","a","I","u","E","o"}, each _ <= x)) 
          )
      )}}
  )
in
  Transform

@jazzista1967

HI Mathias: Great example.... however, my head just exploded into many pieces.  I really like your parameter X to get all the vowels lowered and upper cased ... I like your first solution where you created the parameter. I think it's much more straightforward.  Thanks for sharing