FIND N using multiple criteria

FIND THE LAST OR Nth OCCURENCE IN EXCEL USING MULTIPLE CRITERIA

Crispo Mwangi | 3-Feb-17 | Leave a Comment

In the previous article, we looked at 7 ways to find the last or Nth occurrence in a Sorted list in excel. Unsorted list poses a challenge since you need to find the occurrence using multiple criteria. To show the different methods I have created a list of Customers and their Purchase Orders (P.O). You can download […]

FIND NTH IN EXCEL

FIND THE LAST OR Nth OCCURENCE IN EXCEL (SORTED LIST)

Crispo Mwangi | 27-Jan-17 | Leave a Comment

Finding the Nth or the Last value in a sorted or unsorted list can pose a challenge if you do not understand which functions to use. This article will show you different ways to carry out this sort of find and retrieve in a sorted list. How to handle unsorted list will be tackled in […]

Reverse lookup with duplicates

REVERSE LOOKUP WITH DUPLICATES IN EXCEL

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

It is good to be able to do a Reverse Lookup but it is Awesome if you know how to return Multiple Items. Before you continue with the current article, Please revist the Previous Article on reverse lookup as this is a continuation. Suppose you are managing a project and you have below scheduled dates, […]

reverse LOOKUP

REVERSE LOOKUP IN EXCEL

Crispo Mwangi | 3-Sep-16 | 2 Comments

In my research and tutoring excel, I have found that many  people find Reverse lookup concept to be among the top 10 complicated things in excel. This article hopes to shed more light than heat in demystifying the Reverse Lookup in excel. In the normal lookup, we use the Column and/or Row header to return the value that […]

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 […]