Forum

Hello, As Jessica writes, we can only guess as there can be different scenarios behind this message, just search, One of the scenarios is that ther...

Hello, One way to solve this is if you reference the task name instead of the id number, as the task name remains the same. To avoid typing the tas...

Hello, The simplest solution would be using a Pivot Table. Br, Anders

Hello, If you don’t already have, do a file copy of file A as a backup just in case. Open file A and save a new copy using Save As. Rename file ...

Hello, If there is only one drop down list then you can try using a PivotTable and its filter field, as described in the blog post searchable drop ...

Hello Mesa, Please see the attached modified copy of your sample file, hopefully I have added some useful tips on how to solve your problem. Whe...

Hello Ravi, Take a look at this information about XIRR function, it states that the dates can be in any order, but that it must be in a date format...

Hello, Indirect do work just fine, you just need to ensure you reference the sheet correct. Take a look at this blog article, it will guide you. ...

Hello, Try selecting the column (I assume all data is in a range or table) and press Ctrl + 1, in the Font tab, choose Regular and click OK. Br,...

Hello, This post is a bit off topic for this forum, but I give it a try anyway to see if we can find out where the issue lies. Access handles de...

Hello, In Access design view, change the number field to: Data type = Number Field size = Single Format = General number Access will then sto...

Hello, You can also read the blog article on this topic. Br, Anders

Hello, Your example is not showing the expected result you want, but I assume you want to create dependent data validation lists. Check out the lin...

Hello, Ok, even if the values are text you can use Power Pivot with the help of a measure to show the text data as values. See attached file for su...

Hello again, In attached file you now have such Pivot Table and I have used Power Query to rearrange the data structure to correct one. Br, Ande...