Forum

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...

@leif-norindergmail-com I den bifogade filen kan du se hur min formel funkar, i tre steg. Visst finns det ett område. Jag har bara gett det namnet ...

@leif-norindergmail-com Nej jag har inte släpp frågan, men kan inte förklara varför det inte funkar för dig. Du har en modern Excel version och bor...

@alwaysdave Oh my! That's ancient. Don't really recall how limited that version was compared to modern Excel. Let stick to a simple solution then. T...

@alwaysdave Which Excel version do you work with?

Did you name the matrix with the 1's and 0's "pattern"? Otherwise replace the word pattern in the formula with the range reference of the matrix.