Excel Forum
Similar Content
Easy Way to Manage Names in Excel
Tutorial: How to manage Names in Excel so they are easy to view and change as needed. This is a li...
MODE() - Find Most Repeated Value in a List in Excel
Tutorial: The MODE() function in Excel allows you to quickly find the most repeated or frequently oc...
Wildcards in Excel
Tutorial: Wildcards are characters that allow you to make more robust functions, searches, and filt...



Excel Name Trick #6: Names COUNTIF & wildcards


See how to use the Names & Wildcards with the COUNTIF function. Search through a list of Addresses and count just the ones on Birch Street. Search through a list of Addresses and count just the ones on the 9000 block of Birch Street.

See the wildcard *
See the wildcard ?

This is a logical (beginning to end) story about most of the use for Excel Names. In this series you will see 12 amazing uses for Excel Names (14 total Name Tricks).





Got a Question? Ask it Here in the Forum.