Forum

Hello, One easy way to solve this issue is to check if the filter results in an error, if so it is because it can't find any matching data to filte...

Hello, Relations in Power Pivot is not the same as relations in a relational database. I have made some adjustments, in so making Table B a fact ta...

Hello Andy, Sorry, no file is attached. While at it, please add some sample data also if it is not already existing. Br, Anders

Hello, I need a formula that compared qty within E2 and K2 So if qty of the carton is less 200 then display Q2 and R2 if 200 equal to or more tha...

Hello Dan, Sorry, no file attached. You need to click the Start Upload button after you have added the file. Br, Anders

Hello, Can you attache a file with sample data, as it is now I am just guessing how your data looks like. Br, Anders

Hello, Yes, if the data is already imported you often use the IF function in a helper column to determine what to do. It can also be handled during...

Hello Deepak, I am sorry, I am no coder. Wasn't the article I linked to of any help? Br, Anders

Hello, Create a third table containing unique batch numbers, then create relationships. Table A * —— 1 Table C Table B * —— 1 Table C Br, And...

Hello, You made a good effort trying to explain, but you did not attach a sample file. Br, Anders

Hello, Your file is empty. However, check out this article linked to below and have a go at it. Br, Anders

Hello Cynthia, I assume you refer to Power Query and load files from folder. I would go for such approach. Not knowing what data you have, but if y...

Hello Derek, I understand what you are trying to achieve, but even though Excel can handle big data in the Data Model it is not a relational databa...

Hello James, Just simply wrap it with the TIME function. In cell E2: =TIME(HOUR(NOW()),MINUTE(NOW()),0) Br, Anders

Hello, The asterisks are wildcard characters which makes it possible to make a fuzzy search. More info about wildcard characters in Excel can be fo...