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