Forum

Hi Juliana, Do check these blog posts, I am pretty sure they will give you the guidance needed. https://www.myonlinetraininghub.com/calculating-t...

Hi Paul, Glad you found the solutions useful. Even though we use functions that are volatile they are useful and don't make any fuzz in a file with...

Hi Paul, Not sure why you use the INDEX function, I don't see any need of it as one and each of the site names are unique. Anyway, I simplified you...

Hi Dritan, Have you considered using Power Query? With PQ this is an easy task, do check it out. One example of how you work with PQ.Another exa...

Hi Pam, Do check out this blog from Philip, it contains lots of useful stuff. What you can do is to use =GET.CELL function in a defined name to e...

Hello Teddy, One simple trick is to add a new column in your source data, name it like ID or something like that, and then add for example numbers ...

Hello Dritan, Personnally I would do as Frans suggests, giving each person a copy of the file containing only their sheet. I would then use Power Q...

Hi, Great that you found out the reason of the error. It is almost always those little things you don't think of that are the culprits. /Anders

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