Forum

Lionel Baijot
@questvba
Estimable Member
Joined: Sep 9, 2020
Topics: 8 / Replies: 117
Reply
RE: PowerQuery - SharePoint (https)

I'm also exploring the Power Automate option. If I see a solution, I'll post it here. BR, Lionel

4 months ago
Forum
Reply
RE: PowerQuery - SharePoint (https)

Thanks, Velouria. And I apologise for the confusion between 365 and online. Probably because I use Microsoft 365. That wasn't the problem. Unf...

4 months ago
Forum
Topic
Forum
Replies: 4
Views: 181
Reply
RE: Friday of each week or previous working day

In fact, this treatment is just the tip of the iceberg. So it's not possible to carry out the treatment manually. So I'm trying to replace Excel formu...

1 year ago
Forum
Reply
RE: Friday of each week or previous working day

Thanks for the recording tip. I can see how you did it. It's a good solution and it works perfectly! I hope I never have a bank holiday on Wednesday,...

1 year ago
Forum
Reply
RE: Friday of each week or previous working day

Hi Riny, It's actually an identical process that I wanted to put in place but I can't manage it. I feel like I'm doing something complicated when t...

1 year ago
Forum
Topic
Forum
Replies: 6
Views: 139
Reply
RE: External table is not in the expected format

Hi, It seems that the db is falling asleep. So I created a little 'WAKE_UP' macro and everything seems to be working. Thanks for your comment...

2 years ago
Forum
Topic
Forum
Replies: 3
Views: 116
Reply
RE: Item Analysis- Calculation of the Difficulty Index& Index of Discrimination Computation for Each Item on the Attitude Test

Hi, This is an excellent question. However, it's difficult (even risky) to answer without knowing a bit more about your problem. The easiest way wo...

2 years ago
Reply
RE: Convert Excel formula to power query

Hi Moshe, See in attachment. BR, Lionel

2 years ago
Forum
Reply
RE: Calculate Longest Series

Hi Zoltán, See in attachment. BR, Lionel

2 years ago
Reply
RE: Removing duplicate values based on results from two columns

Hi Tracey Hartley, Can you attach a file with anonymised data that shows the basic data to be processed and then the result you want to achieve? ...

2 years ago
Forum
Reply
RE: VCards to table

Hi Geneviève, Can you attach a file with anonymised data that shows the basic data to be processed and then the result you want to achieve? BR, ...

2 years ago
Forum
Reply
RE: automating update process

Hi Yuan Zhang, Can you attach a file with anonymised data that shows the basic data to be processed and then the result you want to achieve? BR,...

2 years ago
Forum
Page 1 / 9