Last seen: Jun 14, 2025
@j8150outlook-com not sure that I fully understand, though that template merely displays 8 weeks at the time. You probably can't see more on a mid-s...
@navsal66 Try this one: =SUMPRODUCT(--ISNUMBER(FIND(E4,$B$4:$B$11))*$C$4:$C$11)
@navsal66 I believe this does what you need. =FILTER($C$4:$C$11,ISNUMBER(FIND(E4,$B$4:$B$11)),"-")
@knutjdahl I'm afraid that the structure of your table isn't suited for what you want, other than what you described. The attached file contains a s...
@orianfnlc-org-au The list source must indeed be a reference to a single row/column or a delimited list that you may type into the list box, For ex...
@kna Your question in English: "Hello Sir, given the simplicity with which you solved my problem can you give me the algorithmic logic that you f...
@orianfnlc-org-au You should NOT enter "F3" in the source box but click inside the box and press the F3 (function key). That brings up the Paste Nam...
@kna Sure. what is does is concatenate the values from three cells using the &-sign and TEXT function to format numbers in a particular way. T...
@knAPS Perhaps like in column T in the attached file??
@kna OK, then that is indeed the formula you had in your file. According to my "translator" your last message reads as follows: "In fact it is du...
@kna No worries! I understand you want an improvement on your the formula you pasted. Though, it's in French and I'm not sure it's the same as i...
@kna Can't respond to you in French, sorry. From what understand is that the long formula you have is not giving the correct result. Perhaps the for...
@andysibbs Indeed, connecting to a folder will combine all files by appending them, i.e. stacking them on top of each other. Now, I understand that ...
@navsal66 That would be: =MAXIFS(B2:B6,A2:A6,E2)
@elsabchugmail-com I was referring to the tab where I had entered a formula. So, that's the prior week tab. Based on the data you have in the Daily...