what has been done when you applied filter on any table in MS Excel
Share
what has been done when you applied filter on any table in MS Excel
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
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,