Say I have the following table, and I want to get all rows where COL2 = 2 and 3
| A | B | |
|---|---|---|
| 1 | COL1 | COL2 |
| 2 | A | 2 |
| 3 | S | 3 |
| 4 | F | 4 |
| 5 | E | 5 |
When I run the following formula:
=FILTER($A$2:$B$5,(B2:B5=2)*(B2:B5=3),”No Match”)
I get “No Match”. It seems when I remove one of the criteria, there is no issue with meeting the other criteria. However it seems like I cannot run both criteria concurrently. Anyone know the reason for this?
I have 3 shipping methods enabled. But I want to hide one particular shipping method(regular ground ship) if free shipping is enabled […]
I installed https://github.com/DivanteLtd/magento2-vsbridge-pagebuilder/tree/develop this module to use convert cms page builder content HTML to JSON format. But only the banner, image, and […]
This is my first time using AWS to host a NodeJs (v14) application. I connected via SSH and cloned repository and tried […]
I am looking to wire my entire home with Ethernet, to do so I have already laid out conduit pipes for the […]
