by Crispo Mwangi | Aug 20, 2016 | INTERMEDIATE EXCEL
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 Using below sales data lookup and sum the...
by Crispo Mwangi | Aug 7, 2016 | INTERMEDIATE EXCEL
Array formulas come in handy when you want to look up and sum a large amount of data. Array formulas can replace multiple normal formulas, perform multiple calculations and return a single value as a result. For example, using below Main sales data in Quantity and a...
Recent Comments