Forum

Hi Jeana, No, I have not seen any errors in the pivot tables I have been working with that didn't originate from bad data inputs. That said I have ...

Hi Robert, When checking the file it is empty for me. Br, Anders

Hello, Now I don't know how your real scenario / file is, but based on the provided table and question I would say you should use DGET or an array ...

Hi, I am not sure if this blog post will give you any extra info, but perhaps. Seems to me that there are different functionality of PQ depending o...

Hello Mitul, The formula you need to use is: =IF(OR(HOUR(G8)<8,HOUR(G8)>17),"Home","Work") Br, Anders

Hello Mitul, I don't understand why you included column D in your formula. The question is: "Do our customers shop at work (most likely between 8:0...

Hello, Do you have a sample file to share, it would be much easier for anyone to give you some help. Br, Anders

Hi Mitul, Any progress with the formula? /Anders

Anders Sehlstedt said Hello, When trying to play the video for lessons 7.07 and 7.09 I get an error stating "html5: Video file not found". Playing l...

Hello Mohamed, Please explain with details what the issue is, as I can't see any. I assume you expected to see some data connections, but if no dat...

Hello, What I do is to create a copy of the file and in the copy I add comments or whatever suits best to give information of each data set, condit...

Hello Mitul, It seems to me you are doing some training, so instead of giving you the answer, please do try to write an IF formula and then let's s...

Hello Mitul, I don't see what you have trouble with, you have all needed data and you just have to set up the Pivot Table as to your needs. If you ...

Hello, Assuming you have an .xlsx file. Apart from the obvious, remove data you don't need and keeping pictures and formatting to a minimum, you ca...