I have a spreadsheet with 10,000+ rows of data within 5 columns (A, B, C, D, E). I need a formula that will check to see both of the following:

1. Does multiple cells in one row match exactly what any other row has? (Ie. Do cells A2, B2, and D2 together match any other row?) if so, then “Duplicate” 

The example is listed below. There are multiple rows that have both the ID number and scholarship name but only row 1 and row 4 have matching ID number, scholarship name, AND season. I need the formula to be able to search all 10,000 rows in my spreadsheet and tell me if there are multiple rows that match in Columns A, B and D.

2. The next formula is to catch if someone has a two scholarships that conflict with one another. 

Ie. someone cannot receive both a Presidential Scholarship and a Music Scholarship. I need a formula that will look through all 10,000 rows of these 5 columns and return “FLAG!” if an ID number in Column A match and has both the “Presidential SS” and “Music Sch” listed for the same season (in this instance “FALL”). 

So because A1 and A3 both have the same ID, B1 and B3 show both scholarships, and D1 and D3 both list the same season “FALL”, I need G1 and G3 to both return “FLAG!”

Any assistance would be greatly appreciated!

​I have a spreadsheet with 10,000+ rows of data within 5 columns (A, B, C, D, E). I need a formula that will check to see both of the following: 1. Does multiple cells in one row match exactly what any other row has? (Ie. Do cells A2, B2, and D2 together match any other row?) if so, then “Duplicate” The example is listed below. There are multiple rows that have both the ID number and scholarship name but only row 1 and row 4 have matching ID number, scholarship name, AND season. I need the formula to be able to search all 10,000 rows in my spreadsheet and tell me if there are multiple rows that match in Columns A, B and D. 2. The next formula is to catch if someone has a two scholarships that conflict with one another. Ie. someone cannot receive both a Presidential Scholarship and a Music Scholarship. I need a formula that will look through all 10,000 rows of these 5 columns and return “FLAG!” if an ID number in Column A match and has both the “Presidential SS” and “Music Sch” listed for the same season (in this instance “FALL”). So because A1 and A3 both have the same ID, B1 and B3 show both scholarships, and D1 and D3 both list the same season “FALL”, I need G1 and G3 to both return “FLAG!”  Any assistance would be greatly appreciated!  Read More

​