Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Jun 7, 2025
Topics: 61 / Replies: 1572
Reply
RE: Need help in Filtering the Current stocks holding

Nothing attached. Did you click the Start Upload button after selecting the file and then wait for it to upload? Regards Phil

2 years ago
Reply
RE: Merge Not Working After Ranking Within Group

Thanks for posting back and letting us know it worked. Phil

2 years ago
Forum
Reply
2 years ago
Forum
Reply
RE: Merge Not Working After Ranking Within Group

Hi, I had a hard time understanding the issue because your explanation wasn't specific and the file had 4 queries so I had to wade through it all a...

2 years ago
Forum
Reply
RE: Pivot table sort with a slicer

Hi Brandon, If your file size exceeds the forum limit you can put the file on OneDrive, Google Drive or Dropbox and then link to it. Regards ...

2 years ago
Reply
RE: Pivot table sort with a slicer

Hi Brandon, We're happy to help you but please don't post the same question in more than one of our forums, it just makes more work for everyone ei...

2 years ago
Reply
RE: Transform Data using delimiters in Power Query

No worries Mike. Thank you for your kind words, glad to know we are able to help. Regards Phil

2 years ago
Forum
Reply
RE: Transform Data using delimiters in Power Query

Hi Mike, Please see attached file for solution. Looks like you are an Arsenal fan? They're doing well this season, big game coming this week agai...

2 years ago
Forum
Reply
RE: Problem setting two different ranges on visible rows, with different filters.

Hi Samira, No file attached. You have to click Start Upload after selecting the file. Regards Phil

2 years ago
Forum
Reply
RE: Documents control through excel

Hi, Please read this post and use the code in it Create Hyperlinked List of Files in Subfolders Regards Phil

2 years ago
Forum
Reply
RE: PowerBi

Hi, Please supply some sample data and explain exactly how your data 'is off'. What are you trying to do with it? What is the result you are af...

2 years ago
Forum
Reply
RE: Sort Machine Name by most recent date

Hi Moshe, If you are loading and combining all the files from the same folder then you should have a main query and a bunch of other Helper Queries...

2 years ago
Forum
Reply
RE: Sort Machine Name by most recent date

Hi Moshe, You need to be explicit about what you mean by 'recent'. Please give an example of what you want as a result based on some sample data...

2 years ago
Forum
Reply
RE: Sort Machine Name by most recent date

Hi Moshe, You can do this by creating a query (from blank) that gives you today's date using Date.From(DateTime.LocalNow())) You can then merge ...

2 years ago
Forum
Reply
RE: VBA Refrenence

Hi Moshood, Please supply your file with this code in it. Without your file/data how can we test the code is doing what you want? Regards Ph...

2 years ago
Forum
Page 11 / 109