Forum

Anders Sehlstedt
Anders Sehlstedt
@sehlsan
Prominent Member
Joined: Dec 7, 2016
Last seen: Aug 30, 2025
Topics: 8 / Replies: 970
Reply
RE: Power Query add-in (Office 2010) disabled since loading Power BI

Hi Teri, Do check this support page at Microsoft and see if it solves your problem. Br, Anders

8 years ago
Forum
Topic
Replies: 4
Views: 229
Reply
RE: Excel Pivot Tables in Italian / French / German

Hi Steve, Glad that you found the answer. When searching for a list of language id:s to use with the TEXT function I found this article (one of man...

8 years ago
Reply
RE: sumifs with sumproduct and name range

Hello, I found your issue very interesting so I have played around a bit. See the attached sheet to see my attempt to explain why you get 100 as th...

8 years ago
Reply
RE: Analyzing Weekly Changes on a Rolling 4 Week Basis

Hi Paul, A simple solution is to use ROW formula to get the row number. Your formula in cell W3 is currently: =HLOOKUP($W$2,$B$2:$T$251,2,FAL...

8 years ago
Reply
RE: Changing tab (ribbon) order in excel

Hi Celeste, You go to File - Options and in there you choose "Customize Ribbon" on the left. You can organize the ribbon by just re-arranging the o...

8 years ago
Reply
RE: Excel Pivot Tables in Italian / French / German

Hi Steve, I would download respective language packs and check myself. Br, Anders

8 years ago
Reply
RE: Pivot Table Calculated Fields

Hi Brenda, Have you checked this great tip in the Pivot Table blog? Br, Anders

8 years ago
Reply
RE: Find the Relative position of characters within the Cell

Hi Dritan, Great that the formulas works and thank you for the feedback. Br, Anders

8 years ago
Reply
RE: Find the Relative position of characters within the Cell

Hello Dritan, Check this page for more information in how to use Substitute function to count how often a character is used in a string. Count char...

8 years ago
Reply
RE: =Rept

Hello Ahmed, If you check the course sample files you can download you'll see that Playbill font is often used. You can use other fonts as well, fo...

8 years ago
Reply
RE: Time issue in chart but not in table

Ha ha, you got me there. I work either with tables or PivotTables in Excel, so I usually don't need to use named ranges. But as this issue has show...

8 years ago
Reply
RE: Time issue in chart but not in table

Hello Mynda, Thank you for the updates. Please also send my thanks to Jon. It works very nice with a regular chart combined with dynamic named r...

8 years ago
Reply
RE: Time issue in chart but not in table

Hello, Thank you Mynda. Yes, by skipping the days in the formatting and only have hours and minutes I get correct values in the chart, but it is a ...

8 years ago
Reply
RE: Formatting Cells in Excel Text Boxes

Hello Paul, As to my understanding you can do this by using VBA. I have not seen any formula that allows you to change the font size. The links belo...

8 years ago
Page 65 / 66