Forum

Anders Sehlstedt
Anders Sehlstedt
@sehlsan
Noble Member
Joined: Dec 7, 2016
Last seen: Mar 8, 2026
Topics: 8 / Replies: 978
Reply
RE: Sport Team Fixture - Index/match?

Hi, I have difficulties in grasping what it is you want, but if you can upload a sample file with the data as you show in your pictures I have a ch...

8 years ago
Reply
RE: Failed to get data from Microsoft Exchange

Hello, Some links that gives some more details of the difference accounts. Br, Anders

8 years ago
Forum
Reply
RE: Is there any formula to get output to automate salesperson name in worksheet attached ?

Hello Mitul, Please refer toto learn more of how to use GetPivotData function. Br, Anders

8 years ago
Reply
RE: Is there any formula to get output to automate salesperson name in worksheet attached ?

Hello Mitul, The purpose of using Pivot Table is to structure the data as you want to present it, often by using graphs. Due to the layout of the t...

8 years ago
Reply
RE: Microsoft Office Excel 2016

Hi, Without any details it is diificult to narrow it down, but here are some tips and advises. If you have O365, try this tool. There are lo...

8 years ago
Reply
RE: Custom arrange month name in slicer

Hello, Check this article, if you scroll down a little you will find a tip on how to sort the months name in fiscal sort order. Br, Anders

8 years ago
Forum
Reply
RE: How to interpolate between asynchronous data samples?

Hello John, I think you might get a tip or two from this blog article (and from many others in this site), check it out and see if it gives you any...

8 years ago
Reply
RE: How to Create a Pivot Table From Multiple Pivot Tables

Hello, No file is attached. Anyway, my approach would be to get access to all the source data, depending of the quality of the source data, work wi...

8 years ago
Forum
Reply
RE: Conditionally format cells based on two conditions

Hello, I think what Mark wonders is why there were more than one condition rule set. I have modified your file a bit Frans, kept the first rule and...

8 years ago
Reply
RE: GETPIVOT deal breaker

Hello, There must then exist a data connection to a SQL database. Go to Data tab and check what connections that exist from Queries and Connections...

8 years ago
Reply
RE: Formula Inquiry for Multiple Skills and Regions

Hello, Checked your attached file a little closer now, so removing my previous post. I am not sure what it is you want to get here, can you elabora...

8 years ago
Reply
RE: Custom Toggles for 3D SUMIF Across Multiple Worksheets

Hi, Check this blog. It should work as you want it. /Anders

8 years ago
Reply
RE: Tabular Data

Hi, It looks to me that you are on track. /Anders

8 years ago
Reply
RE: Help with Excel Formula

Hello, If you can provide a sample file it would be easier to give you a correct answer. /Anders

8 years ago
Reply
RE: Updating Dashboard/Pivots

Hello Sandra, Sorry, but I do not see any file attached. Normally this kind of issue is due to errors in the Excel file structure and not the co...

8 years ago
Page 59 / 66
0