Forum

Hi Bob, I don't think you are using RemoveDuplicates correctly- did you read the link i posted? RemoveDuplicates removes duplicates from a range...

Hi Bax, You can rename the column by referencing its position rather than its name #"Renamed Columns" = Table.RenameColumns(#"Promoted Headers"...

Hi Francis, Please see attached. This query is fragile in that slight changes to the structure of the PDF will break it, but for the example you p...

That said, the Columns array you supply to RemoveDuplicates is a list of the column numbers that contain duplicates so if email is 200 then Exc...

Hi Bob, Debug.Print prints information to the Immediate Window in the VBA Editor/Debugger. So Debug.Print Range("A1").DisplayFormat.Interior.Color...

no worries Bob - no file attached though. Did you click on the orange 'Start Upload' button?

Hi Chris, I'd use a custom function to create a running total. But that aside, your question was actually can you group by field get Index for e...

Hi Chris, Yes I saw that in the workbook so if that is what you want as a result, I don't understand what you are asking for help with as you've al...

Hi Chris, That query is throwing an error because you don't have a Column named QTY but I think that may be beside the point. You've only got 2 ...

You're welcome.

Hi Lionel, I wasn't sure if you wanted the results grouped by caller number or not. The example result in the post (above) isn't the same as the e...

Hi Francis, Do you want the cumulative total grouped by something, like Account? Regards Phil

Hi Bob, Use DisplayFormat.Interior.Color to get the color set by CF e.g. Debug.Print Range("A1").DisplayFormat.Interior.Color see attached fi...

Hi Bob, This works fine for me Sub xxxx() Dim finalcol As Long finalcol = 2 Range(Cells(1, 1), Cells(20, finalcol)).Select End Sub s...

Hi Jamie, That code as you've pasted it works if there is a named range called DataC4 on the ActiveSheet - see attached file. The code will allo...