Excel 2003. I'm wanting a formula that encompasses all 3 requirements:
1. If a number in column A appears multiple times in column B.
2. Then if 2 different pre-determinded names appear in column C (there's
one name per cell) that are in the same rows as the numbers found in column
B.
3. Bring back the count of times the number appears in column B, less the
number of times the 2 names appear in column C (if only 1 name appears, just
the total count of numbers found in column B)