Excel - How To Count How Many Of Each Value In Excel - Episode 1263
500 views · Published 11 October 2010 · 2:02 · Indexed 27 October 2026
Channel: MrExcel.com · 2010 · Education
Microsoft Excel Tutorial: Counting Spreadsheet Entries: How to Count Entries in Excel using Pivot Tables | MrExcel Podcast. Welcome to another episode of the MrExcel podcast. In today's episode, we will be discussing how to count entries in a spreadsheet. This is a common task that many Excel users encounter, and there are a few different ways to approach it. So, let's dive in and learn some new techniques! First, we have a question from Ron who needs to count how many times each model appears in Column B of his data. One way to do this is by using the advanced filter and then a countif formula. However, my personal favorite method is by using a Pivot Table. It's quick, easy, and gives you a great snapshot of your data. Before we can create the Pivot Table, we need to make sure our data is clean. This means getting rid of any unnecessary rows, such as the blank row 2 in Ron's data. Once that is done, we can insert a Pivot Table and drag the Model field to the Row Labels section. This will give us a list of each model and how many times it appears in the data. We can also add any other text field to the Values section to get a grand total. One great thing about Pivot Tables is that they are live, meaning they will update as you add more data. However, if you want to use the data elsewhere and don't want it to be a Pivot Table anymore, you can simply copy and paste values. This will give you a simple report that you can use for other purposes. I want to thank Ron for sending in this question and I hope this technique helps others who may have a similar task. As always, thank you for tuning in to the MrExcel podcast. Don't forget to drop me a note at [email protected] if you have a question for a future episode. See you next time! 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) Count for each Model in this column (00:23) Could use Advanced Filter, but today, a pivot table (00:44) Add headings for your data (01:00) Build the pivot table (01:15) Getting a Count (01:28) Convert to Values (01:45) 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 #pivottable #pivot_table #excelpivot #excelpivottablestutorial This video answers these common search terms: how to count how many of each value in excel counting occurrences of each item in excel how to find the count of distinct values in excel count occurrences of each value in excel calculating the frequency of data in excel summarize data by counting values in excel excel formula to count unique values tallying data frequency in excel excel function to count values counting distinct items in excel Ron asks how to count how many times each model occurs in a column. Today, in Episode #1263, use a Pivot Table to quickly solve the problem and display results. Join the MrExcel Message Board discussion about this video: https://www.mrexcel.com/board/threads/counting-spreadsheet-entries-podcast-1263.1152944/ Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152944/
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