How To Create A Single Formula to Determine If All Parts Of A Project Are Complete In Excel

In this video we’ll create a single formula that can be copied down through thousands of rows that will determine if each student completed a varying number of components of a project. In the process we will use the AND, COUNTIF, IF, INDIRECT, MATCH, and VLOOKUP functions.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply