Excel - Is Text in ANY Column? - Episode 1826
998 views · Published 11 November 2013 · 4:18 · Indexed 21 October 2026
Channel: MrExcel.com · 2013 · Education
Microsoft Excel Tutorial: Counting Rows with Specific Text & Filtering Data - Easy Solutions. Welcome to the MrExcel podcast. In this episode, we will be discussing a common Excel problem - how to determine if a selected item is present in any column of a data set. This question was sent in by two different viewers, and we will be exploring two different solutions to this problem. The first solution involves using the COUNTIF function. We will be looking at all the values in a specific column and checking if they are equal to the selected item. If they are, we will get a true value, and if not, a false value. By changing the formula slightly, we can get a count of the number of rows that have the selected item in any of the columns. This solution is simple and easy to implement. The second solution involves using the auto-filter feature. We will be filtering the data set to show only the rows that have the selected item in any of the columns. This solution is more efficient, but it requires some knowledge of VBA coding. We will be using a simple code to automatically filter the data set based on the selected item. This solution is perfect for those who are not familiar with Excel and want a quick and easy way to filter their data. As a special offer for Veterans Day, we have a free offer for all veterans. Check out the overlay on the screen for more details. And to all our veterans out there, thank you for your service. Now, let's dive into the solutions for our Excel problem. We will be using the COUNTIF function and the auto-filter feature to determine if a selected item is present in any column of a data set. These solutions are perfect for those who want to save time and make their Excel tasks more efficient. In the first solution, we will be using the COUNTIF function to count the number of rows that have the selected item in any of the columns. This solution is simple and easy to implement, making it perfect for beginners. The second solution involves using the auto-filter feature, which is more efficient but requires some knowledge of VBA coding. We will be using a simple code to automatically filter the data set based on the selected item. This solution is perfect for those who want a quick and easy way to filter their data without having to go through multiple clicks. So, whether you want to count the number of rows with a specific text or filter your data set to show only the rows with that text in any column, these solutions will help you achieve your goal. And don't forget to check out our special offer for veterans on this Veterans Day. Thank you for watching the MrExcel podcast, and we'll see you next time for another netcast from MrExcel. Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Two Similar Questions (00:24) Counting Rows with Specific Text in Multiple Columns (01:41) Using Auto-Filter to Show True Values (02:44) Using VBA to Automatically Filter by Selection (03:53) Another Question on Counting and Filtering Rows with Specific Text (04:07) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial Two similar questions: (1) Can I count how many rows contain certain text in any column? (2) Can you filter to only rows that have the selected text in any of 5 columns. Similar solutions, although the second requires a bit of VBA macro code. Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153649/
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920