Last seen: Apr 30, 2025
@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...
Sorry it didn't solve your problem. But please fill in all relevant cells in rows 22:23 manually and explain where the numbers come from. Perhaps I'm ...
@elsabchugmail-com Ooops. Something must have gone wrong. Trying again.
@elsabchugmail-com Hi again. The attached file includes a formula that might work for you. I entered it in P22 and copied it to the right. does tha...
@elsabchugmail-com Really sorry, but I still don't understand. Can you manually fill in some numbers in the Prior Week Comparison?