We want to determine the number of attendees that are exclusively attending either the master class or conference or are attending both events.
Starting with the first participant “Latricia”, we will place the following XOR function in cell D2 of our table.
The reason the above formula doesn’t display traditional cell references is because we are using an Excel table. Excel tables use what are called Structured References instead of traditional cell references.
If we were using a standard table with traditional cell references, the formula would look like so:
The results of the formula appear as follows.
The XOR function returns a “True” response if 1 and only 1 test is true. If more than 1, none, or all tests are true, the XOR returns a “False” response.
If you are familiar with Excel’s logical tests, you know that a 0 zero is interpreted as “false” and any non-zero number is interpreted as “true”. Because of this, we don’t need to write “=1” in our tests. We can simplify the formula by writing it as follows.
Instead of displaying “True/False” as the results, we want to continue our flagging system with “1/0” as the results. This can be accomplished by applying a negation operation to the XOR function (two leading minus signs).
To determine who are attending both events, we will create a similar formula in cell E2 that uses the AND function.