Forum

Hi Anne, It looks like you have a space delimiter you can use to separate the data? Transform tab > Split by Delimiter, then select the Space de...

Hi Budu, Please see the file attached. Mynda

Hi Eduard, Text.PadStart is looking for a text value for the pad. Try putting your zero in double quotes like this: =Text.PadStart( [Article Cod...

🙂 my pleasure.

Hi Jan, I think a VLOOKUP or INDEX & MATCH formula would be better. This isn't a job for IF. With VLOOKUP or INDEX & MATCH you can find ...

Hi Mey, Try this: =SUMPRODUCT(((A$2:A$8="FIN")+(A$2:A$8="OVH"))*(B$2:B$8)) You need to change the AND operator * between your criteria to the O...

Hi Dritan, This is the perfect job for Power Query. See example attached (refer to the second file; dritan_query-1.xlsx). On the 'Query' sheet is y...

Hi again, Please see the revised file attached. Column D contains a formula that I think does what you want. You can change the start and end dates...

Hi Brent, That sure is a brain teaser and given the lack of response to your question, I'm not the only one to think so. I can't say I have an a...

Hi Celeste, Have you tried 'Remove Blank Rows' on the Home tab of the Power Query editor? Mynda

It would be nice if Conditional Formatting accepted dynamic named ranges, but for now it doesn't. You can make your suggestion on Excel User Voice. Th...

Hi Martin, Set up your Conditional Formatting rule and in the Applies To field extend the range to allow for growth in your table. If the user adds...

Hi Eduard, The file attached didn't have a Power Pivot model. Were you hoping to do this calculation in a PivotTable? I ask because you mention usi...

Hi Lisa, Hold the CTRL key while selecting the outer edge of the element you want to move. You should have 4 small pull handles appear on the objec...

Hi Billn, Yes, you can write 'if' statements in Power Query to test columns meet criteria and then filter the rows out that don't so all you're lef...