Which Function Can I Use- Excel Problem SOLVED

I frequently receive questions on my Social Media platforms. I decided in this new series "Problem Solved", to share the problems that might be interesting to other users and solve these problems while explaining the topic, for the benefit to spread. Today's Excel problem is from someone in the Education industry (like me). Listen to the problem in his own words, then watch me break it down and solving it. You can send me your Excel problems and sample files (with no sensitive data) and if I find it useful to others as well I might record a video on that and add it to the series "Problem Solved". To send an Excel problem you can add it as a comment to : Youtube.com/OfficeInstructor Facebook.com/OfficeInstructor www.OfficeInstructor.com I sincerely hope you can keep supporting my channel by sharing my videos, giving a thumbs up and subscribing to my channel. ##################################################### **************************************************************************** You can Master Excel by learning clever techniques that combine Data validation with almost every tool in Excel. My new Book : **************** Data Validation a back door to Master Excel ********************** **************************** is Now Available at ***************************** ************************* www.Amazon.com ******************************** ************************* www.Amazon.com ******************************** My New Book Is Now available on Amazon. It is much more than the Data Validation you know! Through Data Validation I Cover over 60 different Functions, Charts, Slicers, Pivot Tables, Conditional Formatting, Macros, Power Query, Dynamic Arrays, DAX, Data Model and VBA. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Booking a Corporate Training (at Client Site or Remotely) ************************ Book A Corporate Training ************************* ****************************** With Nabil Mourad ************************* ************************* www.OfficeInstructor.com *********************** ************************* www.OfficeInstructor.com ************************ ##################################################### ****************************************************************************