In this QuickTip, Philip takes an invitation list and constructs a series of reports to identify who has responded, how they have responded, along with identifying who has not responded and if any improper responses have been received or otherwise keyed wrong using a series of outer and anti joins.

You can find our introductory and advanced PowerQuery courses through Udemy.

Image Credits: