Find the missing letters in the letter sequence with Power Query

[gargamalebarbosa]

Hi,
How can i find missing letters in the letter sequence with power query ?

Thank you ,

 

[gargamalebarbosa]

Thank you for the mark and the feedback. Nice to read you figured it out on your own.

Perhaps when you have time, you could also help with this thread.
Thank you for all.

All combinations in power query with dynamic column numbers

I have a table consisting of 4 columns. I want to find all possible combinations of the desired columns using Power Query. For example, the A-B-D column, the A-B column, or the A-B-C-D columns. I will write the combinations of the desired columns into a list, and Power Query will generate all...

www.mrexcel.com

 

[ngoctinh87]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Added Custom" = Table.AddColumn(Source, "T", each let 
t= Text.ToList([List])
in  Text.Combine(List.Difference({List.Min(t)..List.Max(t)},t),","))
in
    #"Added Custom"