Forum

Philip Treacy
Philip Treacy
@philipt
Admin
Member
Joined: Oct 5, 2010
Last seen: Aug 18, 2025
Topics: 61 / Replies: 1579
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

3 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

3 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...

3 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...

3 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...

3 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 ...

3 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...

3 years ago
Forum
Reply
RE: Small formula

Hi mymalone, No file attached. Click on Start Upload after selecting the file. Regards Phil

3 years ago
Reply
RE: Extract unique sorted list from two different columns ignoring blank cells.

Hi Vijay, Can you please supply an example file showing the result you are after? Regards Phil

3 years ago
Forum
Reply
RE: Copy and autoupdate lists

Hi Steven, No file is attached - you need to click Start Upload after selecting the file. However, if you look at my example file, you can creat...

3 years ago
Reply
RE: Need help with Excel formulas

Hi Charli, You say you want to work out the sum of B2 and C2 but in your first example, the result you give is the difference? To use the sum as...

3 years ago
Reply
RE: Count Number Of Students in Training per week

Hi Paul, Nothing is attached. Click on Start Upload after selecting the file(s). Regards Phil

3 years ago
Reply
RE: SUM IF cell B11 includes XXX

Hi Wayne, What software are you using? Your screenshots don't look like Excel, this is an Excel forum. Err:508 isn't an Excel error I am famili...

3 years ago
Reply
RE: Please give me suggestions on how how I can get this done.

Hi Mohammed, Nothing is attached. You need to click 'Start Upload' after selecting the file(s). Regards Phil

3 years ago
Reply
RE: Web Scraping with VBA

Hi, nothing attached. You need to click Start Upload after selecting the file, then wait for it to upload. Phil

3 years ago
Forum
Page 12 / 110