Forum

What do you actually see? "folder path of Power Query" does not mean anything to me. Can you upload a screenshot to see what you mean?

Hi, Hard to see the reasons for this process, if it's shared, better to not lock it for editing, and there is no more need to edit in another file,...

Hi Cedric, The x from (x)=> try List.Last(List.RemoveNulls(List.FirstN(Record.ToList(x) ,Pos+1))) otherwise null represents the current row o...

Should be easier in PQ. There are also other ways to get that result with formulas: =LOOKUP(2, 1/OFFSET(Sheet1!B1,MATCH(A4,part_number,0),0,1,MATCH(B3...

Hi Greg, ActiveCell.DisplayFormat.Interior.Color will give you the formatting color. If this color matches the color you're looking for, you can do...

Hi Anne, Add a new column with the formula: =Text.Repeat("z",[Ports]) then split this new column into rows by number of chars (1).

Hi Karen, Use : If Not Intersect(Target, Me.Range("D:F")) Is Nothing Then instead of: If Not Intersect(Target, ThisWorkbook.Worksheets("Keywords...

All you have to do is to replace in the query: = Table.ExpandTableColumn(#"Removed Columns", "Custom", {"Column1", "Column2", "Column3", "Column4"}, {...

Why? Short answer: because you do not read the documentation: It clearly says: Returns the items in list list1 that do not appear in list list2...

Hi Themba, It's easier with Power Query, see file attached: just put all text files in a folder, change the path to that folder in the excel output...

Hi Sumesh, Which is the order of the invoices? There is no invoice date field to detect FIFO order, which is supposed to be by date. Your invoice n...

The second argument of List.Select starts an evaluation of the list, from the beginning of the list down to the last item in the list. The _ is sho...

List.Select will analyze each item from the list. "_" is the current item from the list.

Try replacing: ShColor = Wks.Tab.ThemeColor & Wks.Tab.TintAndShade with: ShColor = Wks.Tab.Color

Oh boy, Step2 = Table.AddColumn(List.Contains(Table.ColumnNames(Source), "Cat"), "NewOne"), is a mess. List.Contains(Table.ColumnNames(Source...