Timeline for How can I check whether a a row exists containing two cells each equal to a different given value?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 20, 2024 at 0:10 | comment | added | M. Justin | @Blindspots I don't necessarily intend for that Google doc to be permanent, so I'm OK with it being in the transient comment as a temporary example that this does in fact work. | |
| Feb 19, 2024 at 21:33 | comment | added | Blindspots♦ | IF function will interpret 0 as FALSE and any non-zero number as TRUE, and the value_if_true or value_if_false can be left empty to return an empty value. So your formula can be simplified to IF(COUNTIFS(rangeA, criteriaA, rangeB, criteriaB), "X",) | |
| Feb 19, 2024 at 19:49 | comment | added | M. Justin | Google sheet with this solution: docs.google.com/spreadsheets/d/… | |
| Feb 19, 2024 at 19:48 | history | answered | M. Justin | CC BY-SA 4.0 |