Forum

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

Hello, If you rearrange your data as shown in Data (2) sheet you can easily get what you want with a Pivot Table. I have not created such Pivot Tab...

Hello, If you search the Internet for ”alternatives to dynamic array functions” you will get some useful sites to check out. Br, Anders

Hello, Another almost identical formula where we skip the frequency part is something like this. =SUM(IF(MATCH($A$3:$A$10,$A$3:$A$10,0)=ROW($A$3...

Hello, I am confused Saliha, in my eyes you have a subtotal already. But if it is the 1,800 result you want, then do a minor change of Lionel’s for...

Hello, I believe that the data behind the headers This week and Total as of this week are based on dates, not text values. If you can get hold of t...

Hello, Issues like the one you have with column G not copying the formula down is often related to some error/issue on the worksheet or in rare cas...