Forum

Andrew Wilkie
@wilkies0106awhotmail-com
Eminent Member
Joined: Nov 13, 2020
Topics: 7 / Replies: 12
Reply
RE: Power Query and Active Directory....slow

I've got it down to ~30 - 45 seconds. Which if you are only looking at the screen, seems to be a very long time. The key appears to be the order I exp...

2 years ago
Forum
Topic
Forum
Replies: 1
Views: 503
Reply
RE: Use remaining balance from the past 3 years upto a maximum amount.

Hi Jessica. I really thought I had. Manged to work it out, at least for the above query. If wanting to sum the last 3 rows : =SUM(OFFSET(E4...

2 years ago
Reply
RE: Plot rankings over time, series labels either side of chart

I've had to select the 1st and last data point for each category and then add data labels to each and align them left and right appropriately. I still...

3 years ago
Reply
3 years ago
Reply
RE: Dynamically update file name references to external workbooks

Thanks. PQ still isn’t my thing. I’ll have to figure it out. Not sure how I’ll teach it to somebody else. The team will want this.

4 years ago
Reply
RE: Excel signatures

Hi, You might be able to use text tags? Create forms (adobe.com)

4 years ago
Reply
RE: How to sort multiple columns??

Hi, I can't see the attachment. Yet what happens if you select all your data and then on the ribbon, Home tab, Editing group, Sort and Filter, S...

4 years ago
Reply
RE: How do you present this data/report?

Thanks, PQ isn't something I've got into yet. I'll check this all out. Thank you so much. A

4 years ago
Reply
RE: Copy & paste from sap data to excel?

Hi, I don't know SAP, but does it not have an export to Excel function? Copy and Pasting - Some ideas. Paste as values only. Copy to notep...

4 years ago
Reply
RE: Lookup data across multiple sheets?

Hi, Can you attach an example. Which version of Excel are you using? A

4 years ago
Page 1 / 2