• Follow
  • Follow
  • Follow
  • Follow
  • Follow

📩: [email protected]: [email protected]: [email protected]

 

  • HOME
  • ABOUT US
    • Our Partners
    • Our Company
    • Our Team
      • About Joan
      • About Crispo
      • About Abied
      • About Levy
      • About John
  • FREE TUTORIALS
    • BASIC EXCEL
    • HR
    • ADVANCED EXCEL
    • INTERMEDIATE EXCEL
    • CHARTS
  • EXCEL CHALLENGES
  • EXCEL MASTERCLASS
  • HOW TO
  • SUBSCRIBE
  • CONTACTS
FIND THE LAST OR Nth OCCURENCE IN EXCEL USING MULTIPLE CRITERIA

FIND THE LAST OR Nth OCCURENCE IN EXCEL USING MULTIPLE CRITERIA

by Crispo Mwangi | Feb 3, 2017 | BASIC EXCEL, INTERMEDIATE EXCEL

In the previous article, we looked at 6 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...

Follow Us

Follows
  • Twitter
    23k Followers
  • LinkedIn
    13k Followers

Categories

  • ADVANCED EXCEL
  • BASIC EXCEL
  • CHARTS
  • HR
  • INTERMEDIATE EXCEL

Recent Posts

  • How to Sort Data from Right to Left
  • The Pain of Losing Data and a quick way to recover it – Stellar Repair for Excel Review
  • How to return Multiple Items using DATEDIF
  • When The TRIM Function Doesn’t Work
  • How to SUM Data Per Week Using Pivot Table

Recent Comments

  • Goutam Porel on COUNT UNIQUE DUPLICATE VALUES IN EXCEL
  • Crispo Mwangi on How to Return Multiple Columns in VLOOKUP Function
  • Aggeliki on How to Return Multiple Columns in VLOOKUP Function
  • Crispo Mwangi on 5 Ways To Extract Numbers From a String in Excel
  • Ashu on 5 Ways To Extract Numbers From a String in Excel

Archives

  • June 2024
  • March 2024
  • July 2023
  • June 2023
  • May 2023
  • March 2023
  • February 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • December 2021
  • November 2021
  • October 2021
  • June 2021
  • May 2021
  • May 2020
  • April 2019
  • August 2018
  • February 2018
  • January 2018
  • December 2017
  • October 2017
  • August 2017
  • June 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
CrispExcel