Forum Discussion

Iron Contributor

Jun 21, 2021

Join the results of two filtered tables in a single range

Hi, I am using the following formula to join the filtered results of two tables. Filter is resulting in 2 rows from 1st table and 10 rows from 2nd table. While the results of 1st table are corr...

Formulas and Functions

office 365

KanwalNo1

Iron Contributor

Jun 21, 2021

SergeiBaklan It is working perfectly except when oddk = 0 and/or evenk = 0

SergeiBaklan

Diamond Contributor

Jun 21, 2021

KanwalNo1

You may modify as

oddK,IFERROR(ROWS(oddarray),0),
m,   IFERROR(SEQUENCE(,COLUMNS(oddarray)),
             SEQUENCE(,COLUMNS(oddarray))),
IF((k <= oddK) ,
   INDEX(oddarray,  k, m),
   INDEX(evenarray, k-oddK, m)
)

If both errors are empty you may wrap IF by IFERROR and return something like "empty table"