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.
0:04:03
0:03:30
0:09:49
0:04:13
0:04:11
0:00:30
0:06:37
0:09:52
0:00:30
0:01:00
0:09:00
0:00:55
0:12:03
0:00:57
0:25:48
0:00:59
0:05:24
0:00:57
0:02:37
0:01:00
0:09:10
0:00:41
0:05:59
0:00:21