Excel Forum
Similar Content
Naming Cells in Excel to Make Using Formulas/Functions Easier
Tutorial: In this tutorial I am going to introduce the idea of Named Cells. A Named Cell is a cell w...
Excel Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...

Mr Excel & excelisfun Trick 59: Custom Lists, Defined Names, PivotTable & COUNTIF Function

See Mr Excel and excelisfun create Custom Lists, Defined Names, a PivotTable & the COUNTIF Function to create a sorted Frequency Table.

Got a Question? Ask it Here in the Forum.