Forum

Hi Scoti, This post describes how to create a stopwatch and is controlled by the value in a cell. Modifying the code should do what you want. T...

Hi, You haven't supplied any data so it's hard to understand what your data looks like. Please, always supply sample data and show your expecte...

Hi Abid, Please, always supply a file so we don't have to recreate your data. You could do this by creating a merged column then filtering out w...

Hi Vicky, You can use List functions rather than merging. You may need to use List.Buffer() to get the best performance. Regards Phil

Hi, Have you read these posts which cover what you need to do Regards Phil

hi Jaryszek, The .. in {1..[Ports]} means include all numbers from 1 to [Ports] Further reading Power Query Lists • My Online Training Hub re...

Hi Ted, Use this URL period1=1595894400&period2=1627430400&interval=1d&filter=history&frequency=1d&includeAdjustedClose=true...

Hi John, If the UPC column is text then I don't know why PQ is complaining that it isn't. Can you supply a file? Regards Phil

No worries.

Hi Tony, You can use List.Intersect to retrieve the make List.Intersect( { Text.Split(Text.Proper([Make and Model])," "), Makes[Make]}){0} B...

Thanks Alan

Resolved.

Answered on Excel Forum

Answered on Mr Excel