Forum

Hello, Not sure why you separate the data as in your example, just makes things more difficult than needed. Attached file shows one way to go about...

Hello, I would do a repair on the Office installation. If that doesn’t help, do an uninstall and after a computer restart install Office again. If ...

Hello, Thanks for the kind words. Just glad I was able to help. Br, Anders

Hello, Have not checked your latest file. A suggestion: If you have these persons listed in a separete table then you can simply add a new IF state...

Hello, My bad, should have tested the formula on a computer also, worked fine for some reason on Excel app on my tablet. See attached for an exa...

Hello, See attached for an example. I had to change your data a bit, nothing major. Hope this helps you forward. Br, Anders

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