non-array

Hello All just trying to get the following array formula to a non-array {=IFERROR(INDEX(TRADES!$D$2:$D$2000,MATCH(1,(TRADES!$A$2:$A$2000=B3)*(TRADES!$C$2:$C$2000=DATE($F$1,$N$1,$E$1)),0)),"")} Thanks

I have a table as below. The goal is to extract only first two shop i.d.s from each country having the status either "Active" or "Completed" or "Discontinued". If there are no shops in the country with that status do not extract. If only one than extract only one. Finally the answer should be in...

A non-array formula to get the last number in Row 1 after "YES" in Row 2. In the first table , the answer is 2. In the second table, the answer is 0 as there is no value after "Yes" Table 1 <tbody> 10 2 20 30 2 Yes </tbody> Table 2 <tbody> 10 2 20 30 2...

Hi, I have been using this UDF to get a list of sorted unique values from a field BATCH in a table TRANSACTIONS in a separate sheet - Function FilterUniqueSort(ByRef rng As Range, ByVal ref As Long) Dim e, x With CreateObject("System.Collections.ArrayList") For Each e In...

Is it possible to return the first non-blank value of a column without using an array formula? The reason for this is irritating as it is but is due to the fact that Numbers on iOS doesn't seem to recognize the array usage in formulas. Any help would be appreciated!