I am attempting to obtain an array of only values that meet certain criteria.
I have an array in which the meeting of these criteria is summarised in a column of TRUE/FALSE for each entry, as such
INDEX MEETS_CRITERIA
1 TRUE
2 TRUE
3 FALSE
4 FALSE
5 FALSE
6 TRUE
7 TRUE
8 TRUE
9 FALSE
10 FALSE
I wish to obtain, in a separate sheet, a list, without gaps, of all indexes that have true in the column "MEETS_CRITERIA", as below
INDEX
1
2
6
7
8
I am attempting this with the below array formula:
{=INDEX(ORIGINAL_ARRAY!$A$2:$A$10, MATCH("TRUE",ORIGINAL_ARRAY!$B$2:$B$10, 0))}
However this returns #N/A.
What is the error in my formula or my approach?