Forum

Anders Sehlstedt
Anders Sehlstedt
@sehlsan
Prominent Member
Joined: Dec 7, 2016
Last seen: Aug 30, 2025
Topics: 8 / Replies: 970
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...

7 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...

7 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...

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

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

7 years ago
Reply
RE: Tabular Data

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

7 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

7 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...

7 years ago
Reply
RE: Joining two ranges as a new matrix

Hello Ahmad, I have problem understanding your question. Please give more details of what you want to do and what you want as a result. There ar...

7 years ago
Reply
RE: Getting error after entering below Getpivotdata formula

Hello Mitul, The formula you have problem with contains semicolon as separator character. That works perfectly fine for me as that is correct for m...

7 years ago
Reply
RE: Linking GETPIVOTDATA to dashboard for ease in updating

Hello Sandra, I will try to give some answers to your question, let's begin with the easiest first. To insert a picture I use the Attachments bu...

7 years ago
Reply
RE: map chart does not recognize state

Hello, As there is no sample files in your post I can't really give any help or advice, but for me it works just fine. I have attached my test file...

7 years ago
Reply
RE: GETPIVOTDATA With Nested ROW

Hello Mitul, This question is not related to this post, so you should have created a new topic. Anyway, the answer to your first question is tha...

7 years ago
Reply
RE: join dissimilar table

Hello, It would be much easier if you can give us some sample files. Is it possible to upload some files having same structure but contains just so...

7 years ago
Forum
Reply
RE: Is there way to copy numbers from 1 worksheet (where numbers are across) to other worksheet (downwards)

Hello Mitul, I have rearranged all your data in a separate sheet. I have cleaned up the document. The reason why you see two dec -18 is because in ...

7 years ago
Page 59 / 66