Forum

Anders Sehlstedt
Anders Sehlstedt
@sehlsan
Noble Member
Joined: Dec 7, 2016
Last seen: Mar 8, 2026
Topics: 8 / Replies: 978
Reply
RE: Power Query Not As Fast As Microsoft Query

Hello, This article has a link to where you can download needed driver plus also some minor information.

7 years ago
Forum
Reply
RE: Percentage difference question?

Hello, Rule of thumb when calculating difference you should always subtract the lesser value from the greater. So it means you then need an IF stat...

7 years ago
Reply
RE: Percentage difference question?

Hello, You must divide with A2. =(B2-A2)/A2

7 years ago
Reply
RE: Probably very simple!

Hello, In this article you have a similar lookup scenario as yours, have you tried this? If it is not working then it would be great if you can ...

7 years ago
Reply
RE: Converting a date to text

Great that you got it to work! I can only say that the blog articles here at MOTH are just great, those and the courses I have taken here have help...

7 years ago
Reply
RE: Probably very simple!

Hello, As this support page mentions, you probably need to enter the formula as an array formula. When checking this article for more info it seems...

7 years ago
Reply
RE: Converting a date to text

Hello Alan, Check out this blog article for more tips and guidance. The formula you want is =TEXT([@[Extract Date]],”dddd”)

7 years ago
Reply
RE: Table Auto Insert New Row with Formula After Hit Enter

Hello, For Honeywell scanners I found this document, see pages E11 and E12. For Inateck I have not found any info that says anything about setti...

7 years ago
Forum
Reply
RE: Table Auto Insert New Row with Formula After Hit Enter

Hello, Some barcode scanners, for example Zebra, do support change of settings to send a TAB code when scanning. What brand do you have on your sca...

7 years ago
Forum
Reply
RE: IF AND Function for 4 outcomes

Hello, Based on the provided example I would use DGET for this. You need to change the layout of your ”input form” to get it to work. Example: I...

7 years ago
Reply
RE: Formatting of Reports - lost when emailed.

Hello, First I want to share a link to a page that describes how column width is determined in Excel. Now some questions. 1) What file format...

7 years ago
Reply
RE: Excel Vba

Hello, Ask the user who worked with it last to restart his or her computer. This often happens when the Excel.exe process is still active even t...

7 years ago
Forum
Reply
RE: Excel Timesheet

Hello, My apologies for not giving you a complete formula in my previous answer. As I do not know how you want this to work, for example where you ...

7 years ago
Reply
RE: Excel Timesheet

Hello, You can use MROUND function to round up or down to nearest half hour. Example: The entered time of 7:12 in cell C3 will with below formu...

7 years ago
Reply
RE: Lookup and return multiple values

Hello and welcome to this forum, If you can, please upload a file containing some sample data. In general it should not be a problem using less ...

7 years ago
Page 46 / 66
0