Question

what has been done when you applied filter on any table in MS Excel ​

Answer 1

Explanation:

Select the range of cells that will be populated with filtered values.

Start the formula with = IFERROR( function to return empty string when an error occurs)

Continue with INDEX(

Select or type in the range reference that contains your original list B:B,