Try this one, select a project name and then click the blue arrow on the left
If you are using Excel 2021 or 365 then the XLOOKUP function will work. You could also then update all your formulas with the newer functions like MA...
@Adam Deathe, I haven't looked because Anders's answer seemed perfect. I'll take a look for an alternative
@Riny van Eekelen: I must confess I did not think of that option, the link mislead mme and it never happened with other files. Thanks for the tip. ...
Hi, in these case you have to use UNION to address multiple ranges. If Not Intersect(Target, UNION(Range("dv_interventions"), Range("dv_output"), r...
Like I mentioned, it's probably the name the user gave to either a UDF or a named range.
Sorry, the file is not readable, no difference, I have no idea how or what you are doing.
Well, then there is something seriously wrong with your file it's unreadable
I don't think it's the formula the OP is interested in but in what the names it's refering to. I would suggest, if the user has the file to list all ...
Hi adam, just a tip, you've added your explanation to the file entering text in different cells. To make it easier for yourself (and others) I sugges...
Goodday, please attach the file using the upload button.
Good day, You mention that if coulumns A, B, C D are matcehd. To what? The column A contains a unique ID so what do you want to match? Maybe I am no...
What's the difference between the two files? No Student names? (as far as I can see) I've attached my modification with the weeknumbers in the ALL D...
Thanks Velouria, I was so focused on the app I was working on that I forgot about that, it's just like Auto_Open which fails when you run it from cod...