Extend Array Formula

[neodjandre]

I am using this array formula which works fine:

=IF(ROWS(K$62:K62)>COUNTIF(accounts_table[§],"=P"),"",INDEX(accounts_table[Account Name],SMALL(IF(accounts_table[§]="P",ROW(accounts_table[§])-ROW(Ledger!$H$17)+1),ROWS($K$62:K62))))

however I need to add another OR condition:

accounts_table[§],"=B"

I haven't been able to make this work. I presume two changes need to happen to the formula above for this to work.

 

[Bo_Ry]

Maybe try
=IF(ROWS(K$62:K62)>sum(COUNTIF(accounts_table[§],{"P","B"}),"",INDEX(accounts_table[Account Name],SMALL(IF((accounts_table[§]="P")+(accounts_table[§]="B"),ROW(accounts_table[§])-ROW(Ledger!$H$17)+1),ROWS($K$62:K62))))

 

[Aladin Akyurek]

Control+shift+enter:

=IF(ROWS(K$62:K62)>SUM(COUNTIF(accounts_table[§],{"P","B"})),"",INDEX(accounts_table[Account Name],SMALL(IF(ISNUMBER(MATCH(accounts_table[§],{"P","B"},0)),ROW(accounts_table[§])-ROW(INDEX(accounts_table[§],1,1))+1),ROWS($K$62:K62))))​

 

[Bo_Ry]

Another one

=IF(ROWS(K$62:K62)>sum(COUNTIF(accounts_table[§],{"P","B"}),"",INDEX(accounts_table[Account Name],SMALL(IF(accounts_table[§]={"P","B"},ROW(accounts_table[§])-ROW(Ledger!$H$17)+1),ROWS($K$62:K62))))

 

[neodjandre]

ok thanks this works

 

[Aladin Akyurek]

ok thanks this works

What does that "this" points to?