Forum

Riny van Eekelen
Riny van Eekelen
@riny
Moderator
Member
Joined: Jan 31, 2022
Last seen: Aug 19, 2025
Topics: 0 / Replies: 1286
Reply
RE: Structure to visualize data

Well, you could start by sharing some example data. Replace any confidential information, like real names, with made-up ones. You can upload a file wi...

1 year ago
Reply
RE: Extracting the name of Month from Text In Power Query

Please elaborate and clarify what exactly you would want to extract from the example texts in your post.

1 year ago
Forum
Reply
RE: Extracting data from multiple Excel files

Makes sense Anders! I totally misread the OP's intentions. Tack så mycket!!

1 year ago
Reply
RE: Extracting data from multiple Excel files

I'm afraid PQ can't create a schedule like you attached to post nr 9. It's a formatted report with boarders, colors, a picture, checkboxes, data valid...

1 year ago
Reply
RE: Calculating Gross Margin and Net Margin in PowerPivot when columns are months.

You may want to have a look first at Mynda's blog post on how to create a P&L with a regular pivot table. It's not all that complicated. Excel ...

1 year ago
Forum
Reply
RE: Extracting data from multiple Excel files

I didn't notice your post number 6 until now. Sorry for being ignorant, but I don't know what you mean. what would you want to extract and how shou...

1 year ago
Reply
RE: Using Calculated Values in SharePoint Lists/MS List

I didn't notice your post until today. Looked at your file but have difficulties understanding what you exactly want. You have successfully applied co...

1 year ago
Reply
RE: Extracting data from multiple Excel files

Thanks for the file. But now please explain what you want to do with it/them. Say, you have 10 of these sheets what data would have to be extracted...

1 year ago
Reply
RE: Extracting data from multiple Excel files

Please upload a file (or files) that demonstrate the actual structure (or lack thereof) of the data. Without that, it's difficult to help.

1 year ago
Reply
RE: Import HTML file

I'm really sorry but don't understand what I'm looking at nor what you need. It's difficult based on a picture alone.

1 year ago
Forum
Reply
RE: Import HTML file

In PQ you can navigate to the Folder containing your files. Press 'transform' and filter for the file extension you want to connect to. In your case "...

1 year ago
Forum
Reply
RE: Help to find and rename Pivot Table Source Data

As I understand, you renamed column headers in a table that sources a pivot table. Correct? Let's say one pivot table (pt) uses the Manager column ...

1 year ago
Reply
RE: Multiple charts from same pivot table

From what I understand, you need to un-share the Pivot Cache for both pivot tables. It is explained in this blog post by Mynda: Excel Pivot Cache •...

1 year ago
Reply
RE: Using Table name for data validation list

@Hans To avoid OFFSET, in modern Excel you use the # sign to refer to an entire spilled array. So, in your example you can refer the named range It...

1 year ago
Reply
RE: Macro to copy the format of a chosen named range to another fixed point

Consider it closed, but you should have informed us about cross-posting in your first post.

1 year ago
Forum
Page 22 / 86