Higher-End Excel Formula Help

Hello. Working on a massive spreadsheet. Background needed to understand question:   - You have (3) Columns, Column A, B and C - These (3) columns are on Sheet "1" - All three columns have the sa...