Hi, Tina, Can you share a file with your (anonymised) data? Can you also specify the error message you get? BR, Lionel
Hi Teriana, The easiest way is to attach a file to see what you are asking for. BR, Lionel
Hi Maride, Here's a solution. BR, Lionel
Hi lea cohen I tried to find out 'The different conditions are written in the Reference Table - each row is a separate condition'. I must admit tha...
Hi Aye Mu, You can have different ways of calculating this number of days. Here are two solutions. BR, Lionel
Hi shashank s, It's very good to be curious. And it's also very curious to write such a post without a little more information; how can I answer...
Hi Mark, Here is one solution. It may not be 100% effective as we don't have all the necessary information. BR, Lionel
Hi Katherine, Pour savoir si ta cellule contient un mot, tu peux utiliser cette formule : =IF(COUNTIF(C38,"*Top Mount*"),"OK","NOK") BR, ...
Hi Aleksandar, Here is a (starting) proposal via Power Query. I put the text to be processed in cell A2 of the 'ORIGIN' sheet. In the 'FINAL' sheet...
Hi, Siddhartha, The problem is the format of your Sales column. When I use the monetary format, it works perfectly. BR, Lionel
Hi Chantal, I must admit that I'm wondering because you say that you won't know the name of your sheet since it will be created by the macro. It is...
Hi, Answering the question at time X is very easy. The problem will come as soon as the data will be modified, will evolve, will grow... The easies...
Hi, Brooke, This error often occurs when referring to an invalid cell range. I prefer to work in a different way: I have added a module 6 which ...
Hi Meriem, It is very difficult to give a precise answer to your excellent question as we have too little information. How are your data organised?...