2way lookup

2 WAY LOOKUP IN EXCEL

Crispo Mwangi | 20-Aug-16 | 2 Comments

The ability to lookup values is a MUST have skills for all excel users. If you cannot lookup you cannot excel in data analysis. In this article I will show you  5  ways you can do a 2 way lookup in Excel. 1. USING SUMPRODUCT For example using below sales data lookup and sum the total quantity for ALL […]

lookup and Sum

LOOKUP and SUM IN EXCEL

Crispo Mwangi | 7-Aug-16 | Leave a Comment

Array fomulas comes in handy when you want to lookup and sum large amount of data. Array formulas replaces multiple normal formulas,performs multiple calculations and returns a single value as a result. For example using  below Main sales data in Quantity and a lookup price table, Calculate total sales for customer Brosina Hoffman?   There […]

WILDCARD

WILDCARDS IN EXCEL

Crispo Mwangi | 23-Jul-16 | Leave a Comment

A Wildcard is a symbol used to replace or represent one or more characters. Excel wildcards are either an asterisk * which represents one or more characters, a question mark ? which represents a single character or a tide ~ used to distiguish between normal characters and a wildcard. A tide is rarely used. Examples: ►M* will […]