How to bypass the FILTER function

Hello,
could you please tell me how to work around the FILTER function, because with Excel 2013, the FILTER function does not work
I should normally have:
=IF(B1=" "," ";IF(COUNTIF(B13:B18,B1)=1,B1,WORKAROUND(B13:B18,A13,A18=$B$1," ")))
how to work around the FILTER function to get the same result.
Thank you in advance

Configuration: Windows / Chrome 86.0.4240.75

2 answers

  • Votes
  • Date
  • Descending date
  1. Hello everyone,

    With the function given==>filter==>advanced filter

    Best regards
    1. Thank you, but how do I introduce it into my starting formula?