Forum

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

@alwaysdave Which formula? Can you attach your file?

@leif-norindergmail-com Okej, men din formel är ganska omständig. Du har en modern Excel version och då behövs inte SUMMAPRODUKT. SUMMA funkar lika...

@leif-norindergmail-com "funkar inte" är lite vag. Vilken Excel versionen använder du? Får du ett felmeddelande? Bifogar gärna din nya fil. R

@lizch All clear! The field "Booking ref" is a text. Although a pivot table can count the number of booking refs, you can't use that filed in a calc...