Hi,
Se attached workbook.
I got this formula in cell G:305
=HVISFEIL(SORTER(FILTRER(FILTRER(E18:M269;(H18:H269>=DE10)*(H18:H269<=DE11));(KOLONNE(E:M)=5)+(KOLONNE(E:M)=7)+(KOLONNE(E:M)=8)+(KOLONNE(E:M)=10));4);"Ingen utbytte")
The problem is that if I increase the number of columns, this stops working.
It's based on the number of columns from A and continues. I need the numbers that all represents a cell here to be dynamic, and not static.
(KOLONNE(E:M)=5)+(KOLONNE(E:M)=7)+(KOLONNE(E:M)=8)+(KOLONNE(E:M)=10));4);"Ingen utbytte")
It reads from colmns 5, 7, 8 and 10. If I increase a columns to add something that has nothing to do with this, the formula stops working.
I can translate this if needed.
Bookmarks