Recent content by dradenpoel

I did another check, one of my named ranges was one row shorter then the other ones. Adapted it to be the same as the other ranges and works now. Thank you for pointing my attention to the named ranges again.

In Dutch we would refer to what you do as "muggenziften". Does not really add something. There is a very clear reference of which range is the named range employee, underneath the formula. I did indeed check the named ranges in excel, even trying with different named ranges and different...

Name = Employee

But does not in excel after adapting the formula for excel ...

Works on the sheetsfile now =ArrayFormula(ERRORIF(INDEX(remark,MATCH(0,COUNTIF($D$5:D5,remark)+IF(employee<>C6,1,0)+IF(week<>$A$3,1,0)+ALS(team<>$A$6,1,0),0)),""))

You can find an example file here: google sheets example file

All data needed is actually there. Thought the image would make this very clear, maybe my accompanying text is insufficient. The countif is part of the matrix formula, which makes the index formula use several arguments to give the resulting list of names. How it works exactly I am still...

Hey there, I googled myself to the point where I don't find the answer and my comprehension of the formula build up is not sufficient. I am making a dynamic lookup and connecting several data columns into an overview based upon a weeknumber. What I have; The list under AD5 is picked up in...

Will give it a try, thank you for the tip

The modem indeed also is a router, it's the one provided by my ISP. Installed a second one after it to have more wifi coverage in the back of the house, and to be "further away" from the internet. So, I'd have to set up a vpn between my 2 LANs

Hey all, Not sure if I am posting in the right place, seems the most fitting from what I found. I have a modem in my home network, to which a router is connected, to the router I have connected a server. From my wired devices (connected to the router) I can access the server share that I...

There is a simple solution, I found now. Using the actual row result instead of a "j" and "n". Then compiling where to look with the indirect formula (since I know where to look no complicated formula is needed) The updated file can be found here...

Hey Ralston18, Though you are completely right, a database would be in place here, I simply don't have the time to get into studying how and what with access... I am merely trying to simplify the creation of the invoices (better word than coupon) within an existing excel setup, now there is...

Hey all, I am making a spreadsheet for making internal coupons. File can be found here: https://drive.google.com/file/d/1Q8qpeDQcD9S7dSXDnW8I_ZoMNMGX3Ma5/view?usp=sharing In short; I have cols that contain info about what's moved, in one of the cols I put a coupon number/name. In another tab...

Weird stuff, replugged all fans one by one, they are rainbow colory nice, however, none of them is spinning. Well, my post subject is solved, thank you for the help @BlueMicrobe