Anthony C
Active Member
Joined: Sep 1, 2019
Follow
RE: Returning first instance of non-zero, non-null item from an Array
The final thing I've tried is this: =INDEX(ColorList, MATCH(TRUE,ISNUMBER(SEARCH(ColorList,$B$2)),0)) This seems to work if I enter it with CTRL...
6 years ago
RE: Returning first instance of non-zero, non-null item from an Array
I have tried it a slightly different way as well, the final two evaluations come out to this: =INDEX(ColorList,SUMPRODUCT({FALSE;FALSE;TRUE;FALSE;F...
6 years ago
Replies: 3
Views: 55