Thanks to you both Mynda and Sunny! We are investigating these solutions and suggestions and I think we'll manage it from here ourselfs. And ot...
Hi Robin, welcome to the MOTH Forum! I think your problem has to do with two things: First the way you make the formula is not correct. The '=Fa...
Well, almost! 🙂 Thanks! I need to have all the negative specs on the left site of the graph and all the positive ones on the right site. The colo...
Love that last one! (The pivot table solution)
Well, when looking at your picture file, it looks like column ´J´ is filled in directly (I mean not with a formula). So then it's not possible. Correc...
I'll come back on this in one or two days from now, sorry but I'm a bit busy at the moment.
I assume you want to use something to present a sorting order even with ties in the scores? If so: you have to add a very little number 'behind the...
Hi Bob, See attached example. I made a helper column where you first substract the weeknr from the dates. I'm not sure if it's possible without su...
As I read it, slicers on Mac can work on the new Office version there. So maybe the boss uses the older (2011) version? And it seems that on the Mac t...
It would have helped me when you showed some more data. The countif works slightly different from the way you approach it. It counts the number of ...
Sorry, no replies, but maybe you can give us a sheet with the working you have and you want in it? Maybe that'll help answering the question!
Welcome here Lisa. I think you're looking for: =IF(A2=1,IF((OR(K2="V",K2="M",K2="D")),J2,""),"") When criteria doesn't match, it gives a blank i...
Here an example. It's not working for values below 15.000, but don't know if you need that? Otherwise the table must be adjusted.
Hi Theo, I'm not sure if I understand your question correct, because of two things in the file. First I don't understand column C, or is that ju...