In this blog post I walk you through a number of different ways to tackle a question. I had a user who had to identify the correct rate for something based on country of origin and product type. You can download the completed file here. Watch the video here to see how it is done.
Excel shortcut keys – FREE
Recent Posts
- Remove unwanted spaces using Trim() and combine multiple entries – 3 ways
- 06 – How to create a chart with a max/min/target line
- Exclude text from your conditional formatting for numbers
- How to create a training roster in Excel .
- IF NOT – Use IFS/Nested If to show correct VAT rate based on country and product type
Categories
- Excel – From The Beginning
- Excel Formulas | Essential formulas
- Excel Formulas | Essential Functions
- Excel Functions | Useful
- Excel Lists | List basics
- Excel Lists | Sorting and Filtering
- Excel Pivot tables | Introduction
- Excel | Advanced Lessons
- Excel | Case Studies
- Excel | Conditional Formatting
- Excel | Excel Beginner Lessons
- Excel | Excel for Small business
- Excel | General
- Excel | Intermediate Lessons
- Excel | Useful tricks
- Personal
- Powerpivot 2010
- Training Records Management
- Using Excel for tracking training