Forum

Hello, You can use following formula to get the period number. =MATCH(1,MONTH(H4)={7,8,9,10,11,12,1,2,3,4,5,6},0) In short, MATCH function lo...

Hello, One way to do this is to use INDEX & MATCH for group 1 and a second for group 2. Example based on your sample file data. =INDEX(C6:J1...

Hello, You need to put the Table.Buffer after the equal sign, as shown below. This post has been linked to previously, so take a look. It is not al...

Hello Carlos, Sorry, no file attached. Br, Anders

Yep, seems to be so. Below quote is from the support site. Note: The Stocks and Geography data types are only available to Worldwide Multi-Tenant ...

Hello, If you have a Microsoft account you can use the stock data types in Excel online. Br, Anders

Hello, Have you tried using IFS or nested IF’s formula? https://www.myonlinetraininghub.com/excel-ifs-function Do a try yourself and if you st...

Hello, Can you share a sample file so we can see your data structure? Br, Anders

Hello, If you haven’t already, take a look at this post. It can surely guide you through this issue. Br, Anders

Hello, Welcome to this forum. As always it is always better to also provide a sample file showing the data and the structure, makes it easier to...

Hello, The file did not get uploaded. From what I notice on your video it seems your data in your drop down lists (some or all) are wider than your...

Hello, Attached is a simple way to do it by using a helper column to get a unique identifier per row. Then you can use VLOOKUP (or any other looku...

Hello, Sorry, but no file uploaded. Br, Anders

Hello, Search the blog section in this site and you will find some good articles, links below to two of them. Br, Anders

Hello, With six different Pivot Tables it is not possible to double click the grand total cell in one table and get a new sheet containing the filt...