Last seen: Aug 30, 2025
Hello Mitul, I can't find anything wrong in your file, for me it works as you want it to, as long as I don't type in only numbers or try to write a...
Hi, You probably know this already, but I give you this tip in case you haven't thought about it. A simple way to get correct code is to record ...
Hi, As I don't write VBA myself I am not really correct person to give advice, but I do know enough to be able to understand what the code is suppos...
Hi Amy, I need to revise my previous reply. As Sunny writes, it does not work to add TRIM() as I mentioned. I am sorry for that. I set up a test fi...
Hello Amy, Yes, it should work just fine. Just give it a shot. =TRIM(SUMIFS('4_Std'!J:J,'4_Std'!G:G,A:A,'4_Std'!H:H,B:B,'4_Std'!X:X,$H$4)) Br...
Hello Lasse, Without any sample file that shows how your data is setup one can only assume and that is quite often not so good. My first thought wh...
Hello, I suggest that you take a look at this blog post and then adapt the code you see being used to your need. It is a good way to learn new thing...
Hello Frans, Great that you found a working solution. Have an Excellent day now! Br, Anders Sehlstedt
Hello Frans, Q1: As a Swede my regional setting for a date is YYYY-MM-DD, so when I type in 16/8/22 or 16-8-22 in a cell that has number format Dat...
Hello Frans, Now I don't know if you intend to have some text in those cells which you are colouring, but if not then a simple and macro free examp...
Hello Hava, As Clark mentions, you can easily do such by using a list or table where you have the different words or sentences listed. I have crea...
Hello Willy, I am not really sure if I understand your purpose here, but I understand it as such that you have a list of names and from that list y...
Hello Elinor, The solution given by Frans is better than the one I am to provide here, but I give you my reply just so you can see how this can be ...
Hello, That's great you found a solution. Br, Anders
Hello Sunny, You're correct. I missed that "tiny" detail that it is a table. Luckily some of us have eyes which they use. Thanks! Br, Anders