Excel Forum
Similar Content
Excel VBA - Create an Array - 3 ways
Tutorial: Ill show you three different ways to create an array in Excel VBA and Macros and how to ge...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
VBA IF Statement in Excel Macros
Tutorial: IF statements allow you to make decisions in your Macros and VBA in Excel. An IF statement...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 634: Text to Text or Number to Number Matches for Logical Formulas


Learn how to build Logical Formulas for counting with criteria or Conditional Formatting so that the comparison is between Text and Text or Number and Number. Text to Number comparisons do not yield matches such as 2003 and "2003". Learn how to convert Text to a Number or a Number to Text to over come this problem.





Got a Question? Ask it Here in the Forum.