Working with a Bitmask Database Value Using Excel

In this video, we explore a real-world problem where the database stores an important value (in this case whether a group has administrative rights) in a bitmask format. We export the results to Excel and then use formulas to display the column value and our desired mask in binary format. We then use the BITAND function to determine which of our values have that mask value set.