Spreadsheet: 802274d1666762380-how-can-i-return-an-array-of-if-function-results-if-test-aligw
Sheet: detail

 |  |  |  |  |  |  |  |  |  |  |  | Range | Num of 'deletes' |  | Matches in range | Count of opposite value in all of column C. | Matches in range excluding final row in range
 |  |  |  |  |  |  |  |  |  |  |  | C2:C2 | 0 |  | 0 | 4 | 0
 | [NAME] | -272.1 | 0101017 |  |  | If the formula in F31 worked it would have a total of |  |  |  |  |  | C2:C3 | 0 |  | 0 | 4 | 0
 | [NAME] | 272.09 | 0101017 |  |  | 27 'deletes'. |  |  |  |  |  | C2:C4 | 1 |  | 1 | 4 | 0
 | [NAME] | 272.09 | 0101017 |  |  |  |  |  |  |  |  | C2:C5 | 1 |  | 2 | 4 | 1
 | [NAME] | -272.09 | 0101017 |  |  |  |  |  |  |  |  | C2:C6 | 1 |  | 2 | 4 | 2
 | [NAME] | -272.09 | 0101017 |  |  |  |  |  |  |  |  | C2:C7 | 1 |  | 2 | 4 | 2
 | [NAME] | -272.09 | 0101017 |  |  |  |  |  |  |  |  | C2:C8 | 1 |  | 2 | 4 | 2
 | [NAME] | -230 | 0101017 |  |  |  |  |  |  |  |  | C2:C9 | 1 |  | 2 | 4 | 2
 | [NAME] | -224.54 | 0101017 |  |  |  |  |  |  |  |  | C2:C10 | 1 |  | 2 | 4 | 2
 | [NAME] | -191.94 | 0101017 |  |  |  |  |  |  |  |  | C2:C11 | 1 |  | 2 | 4 | 2
 | [NAME] | -173.27 | 0101017 |  |  |  |  |  |  |  |  | C2:C12 | 1 |  | 2 | 4 | 2
 | [NAME] | -139 | 0101017 |  |  |  |  |  |  |  |  | C2:C13 | 1 |  | 2 | 4 | 2
 | [NAME] | -124.8 | 0101017 |  |  |  |  |  |  |  |  | C2:C14 | 1 |  | 2 | 4 | 2
 | [NAME] | -88.3 | 0101017 |  |  |  |  |  |  |  |  | C2:C15 | 1 |  | 2 | 4 | 2
 | [NAME] | -68.62 | 0101017 |  |  |  |  |  |  |  |  | C2:C16 | 1 |  | 2 | 4 | 2
 | [NAME] | -42.83 | 0101017 |  |  |  |  |  |  |  |  | C2:C17 | 1 |  | 2 | 4 | 2
 | [NAME] | -40.31 | 0101017 |  |  |  |  |  |  |  |  | C2:C18 | 1 |  | 2 | 4 | 2
 | [NAME] | -38.88 | 0101017 |  |  |  |  |  |  |  |  | C2:C19 | 1 |  | 2 | 4 | 2
 | [NAME] | -32.39 | 0101017 |  |  |  |  |  |  |  |  | C2:C20 | 1 |  | 2 | 4 | 2
 | [NAME] | -32.1 | 0101017 |  |  |  |  |  |  |  |  | C2:C21 | 1 |  | 2 | 4 | 2
 | [NAME] | -19.61 | 0101017 |  |  |  |  |  |  |  |  | C2:C22 | 1 |  | 2 | 4 | 2
 | [NAME] | -5.77 | 0101017 |  |  |  |  |  |  |  |  | C2:C23 | 1 |  | 2 | 4 | 2
 | [NAME] | -5.2 | 0101017 |  |  |  |  |  |  |  |  | C2:C24 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.02 | 0101017 |  |  |  |  |  |  |  |  | C2:C25 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.02 | 0101017 |  |  |  |  |  |  |  |  | C2:C26 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.03 | 0101017 |  |  |  |  |  |  |  |  | C2:C27 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.06 | 0101017 |  |  |  |  |  |  |  |  | C2:C28 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.07 | 0101017 |  |  |  |  |  |  |  |  | C2:C29 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.08 | 0101017 |  |  |  |  |  |  |  |  | C2:C30 | 1 |  | 2 | 4 | 2
 | [NAME] | 272.09 | 0101017 |  |  |  |  |  |  |  |  | C2:C31 | 0 |  | 3 | 4 | 2
 | [NAME] | 272.09 | 0101017 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | [NAME] | -272.09 | 0101017
 | The formula is checking to see how many items from C2:C2 (and then from C2:C3, etc) are equal to C31.
 | If that number is less than or equal to the total number of the opposite of C31 minus the number of items that match C31 from C2:C2
 | (again with the increasing range) however not including C31 itself then show 'Delete' otherwise show '[NAME]'. Like I stated earlier this array of answers will be used in another function.