How to Use COUNTIF with Wildcards in Excel: Fast and Easy Method!

Mr. Devotor

Unlock the full potential of Excel with this ultimate tutorial on how to use COUNTIF with wildcards in Excel! Whether you're a beginner or an experienced user, this guide will walk you through everything you need to know about using COUNTIF with wildcards to perform powerful data analysis. You’ll learn how to handle complex datasets effortlessly by applying these simple yet effective techniques. Boost your productivity and make data analysis a breeze with our step-by-step instructions. Stay tuned until the end to discover hidden tricks that will take your Excel skills to the next level. Don't miss out—subscribe now for more Excel tips and tricks!   Hashtags  #ExcelTips  #COUNTIFExcel  #ExcelTutorial  #ExcelSkills  #DataAnalysis  #ExcelWildcards  #SpreadsheetTips  #ExcelFormula  #ExcelForBeginners  #TechTutorial

Transcript

00:00Hello, in this video we will learn how to use counter with wildcards in Excel.

00:09I have a large data set and I can see that there are 438 rows in this data set.

00:17So I want to search that how many times the word Nawaz have been used in the C column.

00:24So for this you need to use wildcard counter functions.

00:30So first you need to do is, is equal to and then type counter, open the parenthesis and

00:39then select the range.

00:43You need to press control shift and down arrow key to select the entire column.

00:51And then comma, give the space bar, double quote and then staric and type the word Nawaz

01:09and then again staric.

01:12Staric means find that any word match with the word Nawaz and then double quote and

01:20close the parenthesis and then enter.

01:26And here you can see that the 96 times the Nawaz word have been used in the C column.

01:34So I hope you like this video and if you like this video and think the helpful, please share

01:41my video and support my channel.

01:43Thanks.

01:44Thank you very much.

Category

Transcript

Recommended