Forum

@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?

@elsabchugmail-com Thanks for the file, but now please explain what you want to achieve. I don't understand the design of the file, to be honest. I...

@bee Much better, but I can't tell what's wrong. The first picture has no visible entries that comply with the criteria ("Projects" in C and a value i...

@bee The screenshots are difficult to read due to their low resolution. Better to upload your file. Remove any confidential information but leave the ...

Please try to upload the file rather than paste text from it. And please show the expected results.

That's because the manually added columns are by no means linked to the imported data. You could use a technique in Power Query to keep columns K:Q in...

@leif-norindergmail-com Nu har du tappat bort mig. Filen har en formel i G2 som ger resultat i G2:G2, men jag har försökt förklara hur den funkar i...