Hej. om du vill göra "OR" filter i Excel så tror jag att du måste du använda någonting som kallas "avancerat filter" (jättegammalt filter i excel)
Kolla under menyn DATA->sortera och filtrera->avancerat
Då skapar du ett vilkorsområde (det röda i min bild) med samma kolumnnamn som dina data har. Då kan du även skapa ett "OR" genom att lägga villkoren på olika rader för kolumnerna.
Ändrar du på vilkoret så måste du gå in i "avancerat" för att köra det nya filtret
![](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAXIAAADuCAYAAAAk94yFAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAB4vSURBVHhe7d1tbBTXuQfwvyEmYAiBQCHEMq9+qRy3SlLVjbyqo0iEap1+AOqYKkg3pmrXST5gR5fQS4QS9QrBLVDh9QeIzVVCKiUqjlOjq7JWDRKKK+9FKzVErbO69i5gYzkECoQkYAgO+M7ZObMer9f7hmfGs/P/SSPvzFmv/bDmmcfPHM/JuX79+iiIiMi2ZsiPRERkU0zkREQ2x0RORGRzTORERDbHRE5EZHNM5ERENmdoIh8ddfbMRsbP+J2M8ZsXPxO5gRg/43cyxm9e/IYm8nv37slHzsT4Gb+TMX7z4mdFbiDGz/idjPGbF/+UJvI7d+7IRyqekRm/kzF+xm+WKbvXikjiN2/exMKFC+UR4Pbt25g9e7bcM1+gqRp7sR1tW8vlEXNZE38ATdV70SX3gJXY7N2PDfly10TWvv9DaN9Wj/f75S4qsb1tK8z8STA//tj3XnDa+z99/g3MjH9KKnIticey9Iw81I7WC5WovHBaeWutYV384ge3DW1tyrZ9Od4/0K6kNfNZF7/4z1yPbpdX/TcQm7cAQyb/IFgTv+69197/+mo0WfCfYFr8/Ec2a05kZsZ/34l8siQuWNkjGwp0A65f4BeuC2httyKNTZMeYX6B8mNtDaviDzTtxYXNXuzX/+/N34ANJv9iNi3e//KtSjKvRFer+SfzaRG/hcyM/74SeaIkLlh3Rh5CJI+X5yO/3AV0BxxWkY5RT2jlsKAgsSj+AE53VaLGihIsxnR4/yPKn0ZlfzcCJv8nmDbxW8TM+DNO5MmSuGDZGVn5HbobLih5XKnEypVH5v8QC9ZVJP2RX6erq6tR3+3CaxYlNUviHxrCBfnQaqxIrf/5V7cmS9qrZsafUSJPJYkLVr2R46vQfKhFufmZ3LofZF2PsGYQ9Q74QY7Kz8dy+dBq1r3/8SwX/zSmmhY//5HN3IvcGjPjTzuRp5rEBat+tf7o/X70v18fPSPXR/Y/Mj2ZTYtfLcWv1UqNqhSqprMm/nwUrOzCaSvOXDGmS2thqL0VXZVPm57Mpkv8VjEz/rQSeTpJXLDkjBw4ja6Vm+GNno3F5sVmC/5zT4uKTPx7WFCNCdbEn48NNZXo2hszU2OoHe0OfP+H2rcphQyw+Rfm16TT4uffQmbGn/I88lSTuH4e+ZUrV7B48WK5Zw4xd7y1IGbGgiLyAz1YY+qcciviF7+RTJd55NbELymJe5uSwaLTyMXJff8GUy/6mh9/nDnUFsStmR4//6rK7W0w+89JzIw/pUSeTiWuT+T/+te/8L3vfU/uOQ/jZ/yMn/GbIWlrJd12ih57ZIzfyRg/4zdL0kQ+a9asSJWd6qbHHhnjdzLGz/jNktH0w1TxjMz4nYzxM36zGJrIeUZm/E7G+Bm/WXKuXbumfL3RyBfVNnEmiT2WyfFgMCi/DBERGWXKbmMbz4kTJyJ/kONUAwMDWLFihdxzHkfHn5OjflQKGqfi+68w6f03tLVCRETGYyInIrI5JnIiIptjIicisjkmciIim0sxkYsb0VRjm0VLphHZXxheVw5ycsZvdR1yOIGOOuW5Lq/yCsml81xzZR6/3vSNz1pJE7m4a2B19WkUbLZq5Uei7FHRGBr7WwufBy1VOXB5E6cld7Py3O56FMr9RNJ5rhUyiV9vusdnlaSJPH/DfstW2CDKau7mSDLzN+yDWph2oC7HBa+3TlasdZHjkSpUlq76xyq10tWS4fhxdayuQ7yueD2xKa+vz5sd2tfSbemWyZmaEL8QW7mr/wYaW8VnIvbIiazkXg+lLsWxaG7xo6EB8EWq1ma45VGNe70HaDk2ltzCx9Hqr0DN85PXqC1Vu1AaUqtgn0d5/X3aZysJsKoHjXIs1FgBeHwYbY79qgYaF79IzEVoKFO+B1m1hxp7UBWTzGNN6/hMwkRONM14fBMTeFRM4g8fb4W/ogYJ8rjyet2ol+ORE0FPn5IyFeE+9KAMxXKssLhsbMwKkZOSBz5doi2s36nE24O+BN+UbeIzEBM5ka24oRblIpOHcbzVD8/ODHvGhcVKmhtLkh3HWoCyYuv6z6Gg8vtIrCKUVvgRDMnddEy3+AzERE5kpY5jSn3twfo0ftt3v96ICtFekRVsOp87TqRi9aOhSO0dV7WMr4ZNoY+/qBQV6lGdEIL+CpQWyd10TIf4TMJETmSVsBeuqhZUNL4+eSslnsLnUVPRgl0vtcLvWZ/e5+qJClj0jGU/Ol5P3lCx8cu4qnQXI8PeXWhJ0jqalNXxmYiJnMhE/oaisdkTRa2oCY2iW2vwpqwQz9dUwO/3w5NxOa5wN8OHqrHvR2wGz9FOHH8h6rt98LSMfU9FrTUIZTrd0IL4rMLb2BqIt7HlbUyVMlD9OA2Fva4JiVJM79tVGsrg5DKR1e+/0fElZPL7z4qcyKFCQX/Mxb8w+nrkwyyQ7fHpMZETOZS7OYTGHn3roQitNSZUqybJ9vj0mMiJHEv0pLULgeqWXUku2+MbY/ianT/+8Y/llyJyjhUr1XsTDfT3Rz6Ss5j9/vNip4F4sZMXO5WKRv3oQHz/FSa9/2ytEBHZHBM5EZHNMZETEdkcEzkRkc0xkRMR2VzSRK4u9VYttyYE5HEiIpoekiTyAD4arEFbW1tk826+gL1NTOVERNNJkkRejq1bx1brzC93YeWFIXAtfaIMTLp+ZLK1J7VxuSuI1+Jq8iSl1yMfGkT/8nzky10iSlXy9SMnX3uSKLHUE/lQO7btBbbrKnQiSlEK60dOuvYkURIpJfLIBc8DwGttW8E0TpQBB60fSeZLmshFEj+A19C2fwNbKkSZctD6kWS+xIl8qB0HBmuwfwNTONF9ua/1IwshOjHqyvkKudYlkSZJIh9Ef9de3TxysW1DO6etEKXnPtePdDfr1rIsCmKnzyNHiHgbW0PxNra8jalSekc+WLp+pEX4/ivk+2+01GetEFHGnLR+JJmPiZzIBE5aP5LMx0ROZArnrB9J5uOanUQG4JqdzsY1O7MIL3byYpdS0agfHYjvv8Kk95+tFSIim2MiJyKyOSZyIiKbYyInIrI5JnIiIptLmsgDTbr7rGxr5+pARETTTJJEPoShgu3RNTu3L38f9Vyzk4hoWkmSyPOxYcPYUhLlT1fKR0REaeKapYZJq0ceON2Fyqe5RhARpYtrlhopeSIPNEV75KefbgOX7CSitHHNUkMlT+TlW6M98qdP84InEWWAa5YaKq3WSvnW7ajsH2QiJ6L0cM1SQyVO5EPtaNdNUhlqb0XXygIuwkxE6eGapYZKnMjz8zG4d2weeX23C16upk9E6eKapYbibWwNxNvY8jamSumpfnQg/fvvuDVLTX7/0+qRExFlgmuWGouJnIgMxzVLjcVETkQm4JqlRmIiJzKS6JU6dIusWxnnuCM2kxm++PLgvSfklyIn2viTXPnIWbTFd8nZsmbx5eb/XSb3yGmqfrIUr9U499dnzlpi/GbFz9YKEZHNMZETEdkcEzkRkc0xkRMR2ZwNEvli/O4PLpz4w/exVh6ZXDrPtaNsj4+IMpFGIg+gqboamS/ZqSWh8ds77rlyPNs5PX4iMkrKiTxyC1v5+L5cHsTL/96N55Tt5ZPDKFj7BE7ULpaD8VzBW5Hn/x9OyiOTS+e5Fkk7fj0bxEdEpkstkQ+140C3C5uneO3lsx1n8Pt/Kg9+UILfPaV8XLYc70Sq1OW6FsJc/Pq3sY+fxK+16enyc078djnWjHuuoFbB77gXy+PqFvlamqe+Hz0e3SKvZbwJ8UfEVu66WG0WHxGZI4VEPoT2A91wvWbMfcjPXxqOfCxYOtZiKFhbALwfr/K8iVP/EM/PQ8UT8vnL8qA8G4P/uIqz6pEJCtaWoOCEeL1e+JX9is0yEYqTwOZFGDz5qTL2KY5eFgev4ve/vzDpa0218fGLxFyCCvE9RCpv8T3lYdM2fTKfaDrHR0TGS5rIA0316Ha9hg0GrSZx9tIt+Ujn8iD++Il8HOPsp1cxqHws+OGiSFW5VvkIDMP/6U0xHF/09a7gb6ICxhysFIkxchLQPlc7SZhrXPxPLVaSuHJSOjkoT2BxTlzxTOP4iMh4iRN5oAl7sR37jcriijVL58hHOkqVOmnFePEq/KKyXJKHVUoF+9MfKI8vX8Wpi5HR9FwcVk4KWpKci2d/mKe81jDOq6Om0Mcf798i7okuVdMgPiIyXoJEPoT21i6ga290qbe9kd1qbGufuuWXVy1VkkuyinocrbJchJ+6k7dVUhG54PiHJ7BpyTCO/tHctoM+/nhJW0vug5dS/feZyMr4iMh4CRJ5Pjbsb0Nb29i2vRKo3N42ZRX6GveT+K2oqP85iP9Oo6LW2isVawt0rYP0rXliUeTzj+4X/WWxnUnr+7hfE+L/5Eqkx621jaJVNK7ib5O0mhKxOj4iMkcKFzun2JICvC1nT7y9Nk+9EHfkihxMkdZeETJtqyjOdgwqiVNcTNTP6tBmhBgkYfxX8Nb+QQxGnyOqaHHhM7PphpbER0Smc/RtbNfWupSKWFSsslIVszy2KVX+P3vTP7lMQ1bHx9vY8jaujJ+3sTXYXKxcKj7eQr9W0cupjNkh2+MjIo3DF5bQ5m3rZEk1rrI2PlbkrEgZvznxc4UgMgwTORMZ4zcpkXPNTjKSU9fsJDKT4RX5D8t/JvfIaY6fvsSKnBWp3HMeM+N38MVOIqLswERORGRzTORERDbHRE5EZHNM5ERENpc0kZ87NA8LFjw8tjVwOhlJ/QfxyxXzUSK3N0/J40RkqpQq8toPv8L163JrHJFHydk68eYz/wG8dQa9A1+j98gWHK1di/f65TARmSZpIj/bO1M+mgKn6qPVW3Tb0akMnMV7G0VFpySH6Jg+KWjjclcQr7XxIAbkLpns1HEcxRa8+iu5+uezW/HGjwI4y1UriEyXUkV+5AWttZKHE/JY+pQkXfsZ3vhYqd6UCq7zrXLgxTb07lknx6FUdHuxRo4ffjGA3c0iydN0NHD+M+BHJYj9c4e+81y2gshsSRP5c41jbZVP9szAC+sexDk5lpb+MPrwOFatVHdXrHoc6A2Pq6g3HTmJl+R45botE8ZpOluDVSXyIRGZKqWKXLP6lWHsQS7+mkkmX1mIYnyG87Jd0tX5LlBSOKGiI7s6i/O98iERmSqtRA7MRG/gHgpXy910RCryAHY/o/bAf/PBFhzWtVXIXiK/Uf29d8JvTMWrZM+ciEyTJJHnokE33fDcoQdxpHYEz8n9tCjl2hnRExczHCKbF5VyKDn11/ajnbJnLqa91SoVPVnn2eexCe/ipHYB+lQTdv99C9Y+K/eJyDTJK/IjedE55E+1j+CTTKcfPuvFYVSPzVYRWxqzTir3tGHTB/Lzn+nFq0e2yBGyxjr858f/hb5a+V5GLmSnc3Imoqli2m1sB95Zi3V/2YjOP78a7Yt37ZiPg0Vn8CdtChtlFd7GlrdxZfzmxJ9mjzxzA6FAzMVNXhwjIpoKM8TqPnfv3sV3332HkZER3LlzB7dv38atW7cwPDyMmzdv4saNG/jmm2/w1VdiGuJ1fPnll7h27RquXr2KK1eu4PLly7h06RK++OILXLx4EZ9//jmGhobkl1BV7jmDN3r1rZUn0fFzVuNERPeLKwSRYdhaYWuB8ZsTP9fsJENxzU4i4xlekVdXV8s953F6RXKgNcyKnBWp3HMeM+M3rUdORETGmKHAzJkz8cADDyA3NxezZs3C7NmzMWfOHOTl5WHu3LmYN28eHnroITz8sJhPvgALFy7EI488gkWLFmHx4sVYsmQJli5dikcffRTLli3DY489hvz8fPkliIjISKZNPyQiImMwkRMR2RwTORGRzSVP5OcexDptvc77WlgiC4W9cOXkIEdudR3yOBGRiZIk8hk49PJslGprdn6IzBeWyDodqCtqABpD6rx5nwctVS54w3KYiMgkSRK5uP/4CJ7X7lv73AhqAzPBxbwUHcfQAg921st50u7X0VjhRzCk7sbVURet3qNbpIwPw+sSFb1ycoiO6U8K2rjcFcRrubzKCBE5XZJEfhcl5bk4rvVTTuRmfj/yLBPu6wEqSlEk9zU9fZOlViVJV/UoBbz6V6+hxgrA48Nos1uOQ6nod6FUjvs8fjTsY6+GiJJLksjv4ZXOb1CyT/bI993N/H7kWa8QxWXyYTzhPvSgDMWygC8UT+7pG1dRe3zdiBb46z0TxomI4kmcyCMXOvOAt2WP/G3gZV7wnEQYokifVGGxksZ7oBXsHcdagLJiJf0TEd2fhIn83F9zgT3DeEVbo3P1t3i9VtdqcbBIRe0PIrYlXqaV3LEiFbkfDUVqD7yqxQOfrq1CRJSphIl89c9GgB2zdRW4ksSP3EUJbyEueh/woAXHtDZ2xz40+D1YP1luDgXhFz1xeWfI0dFmpJ7G1bZNi/bFxLTHKqWiJyJSJG6tKBV4p5hyqJtHjg9vjFXojuZGc6gRPVVylknkQmaC5Oxuhg9VckaK3NKYdeJu9sHTIj+/KIidPo8cISKn421sDaS/jWXY60JRaw1C3fXRvnhHXQ52lYbQrV3hzDK8jS1v48r4TbqNrfxIBgsF/TEXN5NcHCUiShHvR24Sd3MIjT361koRWmuytxonIvPwfuSmKUR9t3ahU92YxIloKhjeI+eanc7GNTuJjMdV9MkwXEWfF/sYv0kXO9kjJyKyN/bIiYhsjtMPiYhsjomciMjmmMiJiGwuQSLPRcOCh7HuUOxT1OPqvVfm4RDXfSMislTcRH7u0DwlSeeiZM9deUQzA4fWiRtnyfuTf3gPO57i/cmJiKwUN5GvfuWGkqiHMWEG+LlctOM2tkbX8LyNPfql4JI5VY+SFfPHbzs6lYGzeG/jfLx5qhNvRsfW4r1+9dPGxuWuIF5r40EMyF1bcHr8RGSI9HrkZ2ciUHoPY3exvYfCUvkwKSVJ1X6GNz7+Gr0DX6PzrXLgxTb07lknx4GjtXuxRo4ffjGA3c0iyWULp8dPREZJK5GfC89Aecn4dssaZT+oHE+qP4w+PI5VK9XdFaseB3rD4yrKTUdO4iU5Xrluy4RxW3N6/ERkmLQS+erCewj0zpR7qrPKfqlyPKmVhSjGZzgv2wVdne8CJYVwzB/wOj1+IjJMeq0VITgDYxNVZiAcTHHpt0hFGsDuZ9Qe8G8+2ILDurZC1nN6/ERkmPQSubi4idlo0i5unpiNHRjBz1JZ+u18L86InvCA2gPuHfCiUg4ltwarSoCjnbJn3H8Qv6xVKlo7cXr8RGSYNCvye3jl7dsIviDnkb8AfNj5re7iZwLPenEY1XJGhtzSmHVRuacNmz6Qn/9ML149skWO2ITT4yciw5h2G9uBd9Zi3V82ovPPr0b7wl075uNg0Rn86VfZvyy/E+PnbWx5G1fGb0786ffIMzQQCsRc3Dsrug2O4fT4icg4piXyyj1n8EavvrXwJDp+7oxqXHB6/ERkHK4QRIZha4WtBcZvTvw5165dG9UvCCw2sWpQ7LFMjgeDQa7Z6XBcs5PIeIZX5NXV1XLPeZxekRxoDbMiZ0Uq95zHzPhN65ETEZExmMiJiGyOiZyIyOaYyImIbI6JnIjI5hIk8snW7BQSjTlI2AtXTg5y5FbXIY8TEZkobiaefM3OxGPO0oG6ogagMaTOm/d50FLlgjcsh4mITBI3kU+6Zqci0ZijdBxDCzzYWS/nSbtfR2OFH8GQuhtXR120eo9ukTI+DK9LVPTKySE6pj8paONyVxCv5fIqI0TkdA7vjWQu3NcDVJSiSO5revomS61Kkq7qUQp49a9eQ40VgMeH0Wa3HIdS0e9CqRz3efxo2MdeDRElx0Q+ZQpRXCYfxhPuQw/KUCwL+ELx5J6+cRW1x9eNaIG/3jNhnIgoHibyKROGKNInVVispPEeaAV7x7EWoKxYSf9ERPeHiTxDkYraH0RsS7xMK7ljRSpyPxqK1B54VYsHPl1bhYgoU0zkmXKvhwctOKa1sTv2ocHvwfrJcnMoCL/oics7Q46ONiP1NK62bVq0LyamPVYpFT0RkYKJPGNuNIca0VMlZ5lELmQmSM7uZvhQJWekyC2NWSfuZh88LfLzi4LY6fPIESJyOt7G1kD621iGvS4UtdYg1F0f7Yt31OVgV2kI3doVzizD29jyNq6Mn7exzSqhoD/m4maSi6NERCmaIVb3uXv3Lr777juMjIzgzp07uH37Nm7duoXh4WHcvHkTN27cwDfffIOvvvoKSgWPL7/8EteuXcPVq1dx5coVXL58GZcuXcIXX3yBixcv4vPPP8fQ0JD8EiS4m0No7NG3VorQWpO91TgRmWeGAjNnzsQDDzyA3NxczJo1C7Nnz8acOXOQl5eHuXPnYt68eXjooYfw8MMPY8GCBVi4cCEeeeQRLFq0CIsXL8aSJUuwdOlSPProo1i2bBkee+wx5Ofnyy9BqkLUd2sXOtWNSZyIpoLhPXKu2elsXLOTyHhcRZ8Mw1X0ebGP8Zt0sZM9ciIie2OPnIjI5jj9kIjI5pjIiYhsjomciMjmEiTyOOtynsjDAuVY7Ob4tTuJiCwUNwNPui7nc8O4fl3MXJHbJ7dRjhG8/so9+QQiIjJb3ESe6rqcJ5pmo/TDYTwn95M6VY+SFfPHbzs6lYGzeG/jfLx5qhNvRsfW4r1+9dPGxuWuIF5r40EMyF1bcHr8RGSIzHsi5x7EvuBtbE05iytJqvYzvPHx1+gd+Bqdb5UDL7ahd886OQ4crd2LNXL88IsB7G4WSS5bOD1+IjJKxolcVOPYMILVcj+p/jD68DhWrVR3V6x6HOgNj6soNx05iZfkeOW6LRPGbc3p8RORYTJM5Lk4fiTN3vjKQhTjM5yX7YKuzneBkkI45g94nR4/ERkms0R+IhdHakdS740LkYo0gN3PqD3g33ywBYd1bYWs5/T4icgwGSXyE8dzUfv8iNxL0flenBE94QG1B9w74EWlHEpuDVaVAEc7Zc+4/yB+WatUtHbi9PiJyDAZJHLRVrmLkjVyN1XPenEY1XJGhtzSmHVRuacNmz6Qn/9ML149skWO2ITT4yciw5h2G9uBd9Zi3V82ovPPr0b7wl075uNg0Rn86VfpnhXsx4nx8za2vI0r4zcn/oxnraRrIBSIubh3VnQbHMPp8RORcXKuXbs2ql9+TGziHuWxxzI5HgwGdQtLiD9qeRK7/y53FU++5YxqXOW8+FmRsyJl/ObEzxWCyDBM5ExkjD9LEjnX7HQ2rtlJZDzDE3l1dbXccx6nVyQHWsOsyFmRyj3nMTN+rtlJRGRzXLOTiMjmTJt+SERExmAiJyKyOSZyIiKbi5vI1aXetDU583BCHh8TZz1PJwp74crJQY7c6jrkcSIiE8XJxLlo6v02ui7nJ3tm4IWGsbnAk67n6TgdqCtqABpD6l+y+jxoqXLBG5bDREQmiZPIR9DYOHaL2tU/G0F5cAbOafsprueZ9TqOoQUe7KyX86Tdr6Oxwo9gSN2Nq6MuWr1Ht0gZH4bXJSp65eQQHdOfFLRxuSuI13J5lREicrrkvZGzMxEovZf6km4OEe7rASpKUST3NT19k6VWJUlX9SgFvHofmlBjBeDxYbTZLcehVPS7UCrHfR4/GvaxV0NEySVO5OcexLoXgA91FTpNphDFZfJhPOE+9KAMxbKALxRP7ukbV1F7fN2IFvjrPRPGiYjimTSRR3rhLwNvXx9Ob0k3xwpDFOmTKixW0ngPtIK941gLUFaspH8iovsTN5GLJP4yhnG981u2VCYRqaj9QcS2xMu0kjtWpCL3o6FI7YFXtXjg07VViIgyNTGRn3sQL/d+i850Vsh3Ivd6eNCCY1obu2MfGvwerJ8sN4eC8IueuLxX++hoM1JP42rbpkX7YmLaY5VS0RMRKSYmcnFx80iebh652ObhkDZthSQ3mkON6KmSs0wiFzITJGd3M3yokjNS5JbGrBN3sw+eFvn5RUHs9HnkCBE5HW9jayD9bSzDXheKWmsQ6q6P9sU76nKwqzSEbu0KZ5Zw/9v/RD6u+3kpb2PL27jKPecx9Ta28iMZLBT0x1zcTHJxlIgoRUzkJnE3h9DYo2+tFKG1JruqcVGJa9U4EZmHidw0hajv1i50qlu2tVSIyBqGr6LPNTudjWt2EhmPFzsNxIs9jJ/xM34zsLVCRGRzTORERDbHRE5EZHNM5ERENsdETkRkc3ET+VD7tshsE3VrQkAeFxKNERGR+eIk8gA+GqxBW1tbZPNuvoC9TVq6TjRGRERWiJPIy7F1a7l8DOSXu7DywhCGInuJxoiIyArJe+RDg+hfno98uTtOojEiIjIB8P+KYK7LZdPO1wAAAABJRU5ErkJggg==)
Det här anänds nog inte så ofta, trots att det är kraftfullare än vanliga filter. Det är ju lite knöligt att jobba med.
Och jag vette tusan hur man VBA-scriptar. En inspelning av filtret ovanför ger:
ActiveSheet.ShowAllData
Range("A4:B21").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:= Range("D1:E3"), Unique:=False
Men jag blir inte klok på om du kan sätta "CriteriaRange" virtuellt i VBA utan att faktiskt skapa område på bladet. Men du kankse kan lägga villkorsområdet på ett dolt blad och manipulera de inställningarna via kod?
Range.AdvancedFilter method (Excel) | Microsoft Learn