Скачать с ютуб INDEX MATCH - Wildcard - Asterisk and Question Mark | Google Sheets Formulas 25 в хорошем качестве

INDEX MATCH - Wildcard - Asterisk and Question Mark | Google Sheets Formulas 25

In this lesson, We are going to explore: 0:00 Getting started. 0:03 INDEX MATCH Asterisk Wildcard Exercise. 0:18 What are wildcards? 2:51 INDEX MATCH Question Mark Wildcard Exercise. All explanations are simple and to the point. Feel free to make your own copy of this spreadsheet: https://docs.google.com/spreadsheets/... #GoogleForEducation #GoogleWorkspace #GoogleSheets If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded Useful Link: Ben Collins (Google Developer Expert & Data Analytics Instructor) https://www.benlcollins.com/ Google Sheets training: https://support.google.com/a/users/an... The whole playlist link:    • The most useful formulas - Google Sheets |...   Follow us on Pinterest: https://www.pinterest.it/GoogleWorksp... Sound from Zapsplat.com Apple logo https://iconscout.com/contributors/pi... Windows logo https://pixabay.com/it/users/ Welcome back, Educators. Our mission is to extract any cell that has the word ice anywhere it is found. To achieve that, we use wildcards. What are wildcards? They are symbols used to represent one or more characters. The Asterisk (*)matches any number of characters. The question mark (?) matches a single character. To start, we use MATCH to return the position of the cells that have the word ice. The search_key of MATCH is an array of the word ice with an asterisk wildcard. It returns the position of the cell that starts with the word ice. And which has this word in the middle. And also at the end. The range is the open-ended column B. we set the search_type to 0 to return an exact match. Finally, we surround the formula with the ArrayFormula function. It returns the rows numbers that have the word ice. We’ve added a drop-down menu to this cell. That returns all the values in the open-ended column A. And we’ve added a custom number format to facilitate reading the data. Now, we use the INDEX to return the value of each cell. The reference is the open-ended column B. We change the row number dynamically by noosing an item from the drop-down menu. When we select Start with, that returns the cell that has the word ice in the beginning. By changing the drop-down menu item, it returns the cell that is associated with it. Our mission is to extract the cells that have the word Organization. No matter if it is written with Z or S. And here is come the power of the wildcard (?). We could use the same formula that we’ve created before. Just replace its array with this one. That’s it, have fun. Thanks for watching. If you like the video, please give us a thumbs up. And subscribe to our channel.