I have a long list where I want to hide the rows when cell B(row) = #NA

I dont want to use Autofilter, is there a function or maco to hide these rows

Thank you very much in advance

--

There are only 10 types of people in the world:
Those who understand binary and those who don''t.