In this example, the formula uses the LEFT function to find the first letter in each row in column A and compare it to "M". If it matches, it will return 1. If it doesn't, it will return 0. The -- in front of the LEFT function is a trick we need to play on Excel to forc...