Forum

Thanks for the tip Phil! I am now just wondering how on earth I have missed such simple fact during the years I have used Excel. There is always somet...

Hello, Using IFS function is almost as nested IF’s. =IFS(M5<0.4,M6*A3,AND(M5>=0.4,M5<=0.49),M4*B3,AND(M5>=0.5,M5<=0.59),M4*C3,M5&...

Hello, A few suggestions, depending on how the data is coming in to this Excel file. If typed in then it is of course better and easier to type ...

Hello, There are some tools and methods you can use, most of them only looks for exact duplicates. I found a web page here that gives short explana...

Hello, Please have a look at this blog post, it also describes on how you use # character when referencing to spilled data. Br, Anders

Great, I’m just glad I could help. Take care, /Anders

Hello Frans, I have played around a little and by using a helper column I could do one formatting rule that highlights the cells per row that has l...

Hello Frans, See attached file, I have added two new sheets, Sheet2 and data (2). As you can see in sheet data (2) I have adjusted the data to b...

Hello, As Purfleet hints, you should go for a VBA solution to calculate the sales price, the result should be put in the sheet as numbers. In such ...

Hello, As you have posted this in the Power Query section, do you want a PQ solution or do you want a standard Excel formula using VLOOKUP? The ...

Hello, Lots of information and free, check out Microsoft Docs library.

Hello, I have looked up on this topic and it seems it is a lot more difficult to get what you want using Power Query. Although it seems doable but ...

Hello, I am afraid I don't understand what you are looking for here. You write "Need to find the overlapping dates", what do you mean by overlappin...

Hello, One way to do it is to add the files to the folder in batches, for example 30 or 40, then update and if no errors, add next batch and so for...

Hello, If you can upload a sample file and describe in text what the logics are. What is it you want as end result?