filmov
tv
Filter Function Wildcard Match in Excel

Показать описание
This video shows an example of the FILTER Function in Excel with a "wildcard" or "partial" match.
This is achieved by inserting two other functions (ISNUMBER & SEARCH) within the FILTER Function. This illustration explains how to do this and how the nested functions produce the desired result.
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
Learn more about Excel Functions & Features with this book at Amazon:
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
You can download a copy of this workbook at the link below.
This is achieved by inserting two other functions (ISNUMBER & SEARCH) within the FILTER Function. This illustration explains how to do this and how the nested functions produce the desired result.
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
Learn more about Excel Functions & Features with this book at Amazon:
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
You can download a copy of this workbook at the link below.