Timeline for How to check if a cell contains any of an array of values?
Current License: CC BY-SA 4.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 20, 2023 at 3:47 | history | edited | Rubén - Volunteer Moderator -♦ | CC BY-SA 4.0 |
add missing parenthesis
|
| Jun 16, 2020 at 10:46 | history | edited | CommunityBot |
Commonmark migration
|
|
| Apr 13, 2017 at 12:57 | history | edited | CommunityBot |
replaced http://webapps.stackexchange.com/ with https://webapps.stackexchange.com/
|
|
| Mar 28, 2016 at 23:28 | history | edited | Rubén - Volunteer Moderator -♦ | CC BY-SA 3.0 |
Added a note.
|
| Mar 28, 2016 at 23:27 | comment | added | Rubén - Volunteer Moderator -♦ | @snazzybouche: Sorry, I didn't saw that the value of E3 includes both Tim and Frank. See my other answer. | |
| Mar 28, 2016 at 23:03 | comment | added | user79865 | See webapps.stackexchange.com/questions/91339/… | |
| Mar 28, 2016 at 22:59 | comment | added | snazzybouche | this is OP having just made an account. Rubén, I'm unable to comment on your suggestion, but it's not giving me the results I'd like. It's producing the array {TRUE; TRUE} when what I want is {TRUE; TRUE; TRUE; FALSE}. Using MATCH necessitates that the value I'm searching for is equal to the exact content of the cell. However, I'm looking so see if any value from ARRAY1 is contained within any of E1:E4. | |
| Mar 28, 2016 at 22:32 | history | answered | Rubén - Volunteer Moderator -♦ | CC BY-SA 3.0 |