Spreadsheet: 806051d1669080621-how-to-find-the-majority-value-of-a-column-until-a-value-changes-in-another-column-house_example
Sheet: Sheet1

Year | STATE | STATE ABBREVIATION | dist | PARTY | MajorityParty
2020 | Alabama | AL | AL1 | Republican | Republican
2020 | Alabama | AL | AL2 | Republican | Republican |  | `=IF(C4="",C3,INDEX($E3:$E$4376,MODE(MATCH($E3:$E$4376,$E3:$E$4376,0))))
2020 | Alabama | AL | AL3 | Republican | Republican
2020 | Alabama | AL | AL4 | Republican | Republican
2020 | Alabama | AL | AL5 | Republican | Republican
2020 | Alabama | AL | AL6 | Republican | Republican
2020 | Alabama | AL | AL7 | Democrat | Republican
2020 | Alaska | AK | AK0 | Republican | Republican
2020 | Arizona | AZ | AZ1 | Democrat | Democrat
2020 | Arizona | AZ | AZ2 | Democrat | Democrat
2020 | Arizona | AZ | AZ3 | Democrat | Democrat
2020 | Arizona | AZ | AZ4 | Republican | Democrat
2020 | Arizona | AZ | AZ5 | Republican | Democrat
2020 | Arizona | AZ | AZ6 | Republican | Democrat
2020 | Arizona | AZ | AZ7 | Democrat | Democrat
2020 | Arizona | AZ | AZ8 | Republican | Democrat
2020 | Arizona | AZ | AZ9 | Democrat | Democrat
2020 | Arkansas | AR | AR1 | Republican | Split
2020 | Arkansas | AR | AR2 | Republican | Split
2020 | Arkansas | AR | AR3 | Democrat | Split
2020 | Arkansas | AR | AR4 | Democrat | Split
2020 | California | CA | CA1 | Republican
2020 | California | CA | CA2 | Democrat
2020 | California | CA | CA3 | Democrat
2020 | California | CA | CA4 | Republican
2020 | California | CA | CA5 | Democrat
2020 | California | CA | CA6 | Democrat
2020 | California | CA | CA7 | Democrat
2020 | California | CA | CA8 | Republican
2020 | California | CA | CA9 | Democrat
2020 | California | CA | CA10 | Democrat
2020 | California | CA | CA11 | Democrat
2020 | California | CA | CA12 | Democrat
2020 | California | CA | CA13 | Democrat
2020 | California | CA | CA14 | Democrat
2020 | California | CA | CA15 | Democrat
2020 | California | CA | CA16 | Democrat
2020 | California | CA | CA17 | Democrat
2020 | California | CA | CA18 | Democrat
2020 | California | CA | [NAME] | Democrat
2020 | California | CA | CA20 | Democrat
2020 | California | CA | CA21 | Republican
2020 | California | CA | CA22 | Republican
2020 | California | CA | CA23 | Republican
2020 | California | CA | CA24 | Democrat
2020 | California | CA | CA25 | Republican
2020 | California | CA | CA26 | Democrat
2020 | California | CA | CA27 | Democrat
2020 | California | CA | CA28 | Democrat
2020 | California | CA | CA29 | Democrat
2020 | California | CA | CA30 | Democrat
2020 | California | CA | CA31 | Democrat
2020 | California | CA | CA32 | Democrat
2020 | California | CA | CA33 | Democrat
2020 | California | CA | CA34 | Democrat
2020 | California | CA | CA35 | Democrat
2020 | California | CA | CA36 | Democrat
2020 | California | CA | CA37 | Democrat
2020 | California | CA | CA38 | Democrat
2020 | California | CA | CA39 | Republican
2020 | California | CA | CA40 | Democrat
2020 | California | CA | CA41 | Democrat
2020 | California | CA | CA42 | Republican
2020 | California | CA | CA43 | Democrat
2020 | California | CA | CA44 | Democrat
2020 | California | CA | CA45 | Democrat
2020 | California | CA | CA46 | Democrat
2020 | California | CA | CA47 | Democrat
2020 | California | CA | CA48 | Republican
2020 | California | CA | CA49 | Democrat
2020 | California | CA | CA50 | Republican
2020 | California | CA | CA51 | Democrat
2020 | California | CA | CA52 | Democrat
2020 | California | CA | CA53 | Democrat
2020 | Colorado | CO | CO1 | Democrat
2020 | Colorado | CO | CO2 | Democrat
2020 | Colorado | CO | CO3 | Republican
2020 | Colorado | CO | CO4 | Republican
2020 | Colorado | CO | CO5 | Republican
2020 | Colorado | CO | CO6 | Democrat
2020 | Colorado | CO | CO7 | Democrat
2020 | Connecticut | CT | CT1 | Democrat
2020 | Connecticut | CT | CT2 | Democrat
2020 | Connecticut | CT | CT3 | Democrat
2020 | Connecticut | CT | CT4 | Democrat
2020 | Connecticut | CT | CT5 | Democrat
2020 | Delaware | DE | DE0 | Democrat
2020 | District of Columbia | DC | DC0 | Democrat
2020 | Florida | FL | FL1 | Republican
2020 | Florida | FL | FL2 | Republican
2020 | Florida | FL | FL3 | Republican
2020 | Florida | FL | FL4 | Republican
2020 | Florida | FL | FL5 | Democrat
2020 | Florida | FL | FL6 | Republican
2020 | Florida | FL | FL7 | Democrat
2020 | Florida | FL | FL8 | Republican
2020 | Florida | FL | FL9 | Democrat
2020 | Florida | FL | FL10 | Democrat
2020 | Florida | FL | FL11 | Republican
2020 | Florida | FL | FL12 | Republican
2020 | Florida | FL | FL13 | Democrat
2020 | Florida | FL | FL14 | Democrat
2020 | Florida | FL | FL15 | Republican
2020 | Florida | FL | FL16 | Republican
2020 | Florida | FL | FL17 | Republican
2020 | Florida | FL | FL18 | Republican
2020 | Florida | FL | FL19 | Republican
2020 | Florida | FL | FL20 | Democrat
2020 | Florida | FL | FL21 | Democrat
2020 | Florida | FL | FL22 | Democrat
2020 | Florida | FL | FL23 | Democrat
2020 | Florida | FL | FL24 | Democrat
2020 | Florida | FL | FL25 | Democrat
2020 | Florida | FL | FL26 | Republican
2020 | Florida | FL | FL27 | Republican
2020 | Georgia | GA | GA1 | Republican
2020 | Georgia | GA | GA2 | Democrat
2020 | Georgia | GA | GA3 | Republican
2020 | Georgia | GA | GA4 | Democrat
2020 | Georgia | GA | [NAME] | Democrat
2020 | Georgia | GA | GA6 | Democrat
2020 | Georgia | GA | GA7 | Democrat
2020 | Georgia | GA | GA8 | Republican
2020 | Georgia | GA | GA9 | Republican
2020 | Georgia | GA | GA10 | Republican
2020 | Georgia | GA | GA11 | Republican
2020 | Georgia | GA | GA12 | Republican
2020 | Georgia | GA | GA13 | Democrat
2020 | Georgia | GA | GA14 | Republican
2020 | Hawaii | HI | HI1 | Democrat
2020 | Hawaii | HI | HI2 | Democrat
2020 | Idaho | ID | ID1 | Republican
2020 | Idaho | ID | ID2 | Republican
2020 | Illinois | IL | IL1 | Democrat
2020 | Illinois | IL | IL2 | Democrat
2020 | Illinois | IL | IL3 | Democrat
2020 | Illinois | IL | IL4 | Democrat
2020 | Illinois | IL | IL5 | Democrat
2020 | Illinois | IL | IL6 | Democrat
2020 | Illinois | IL | IL7 | Democrat
2020 | Illinois | IL | IL8 | Democrat
2020 | Illinois | IL | IL9 | Democrat
2020 | Illinois | IL | IL10 | Democrat
2020 | Illinois | IL | IL11 | Democrat
2020 | Illinois | IL | IL12 | Republican
2020 | Illinois | IL | IL13 | Republican
2020 | Illinois | IL | IL14 | Democrat
2020 | Illinois | IL | IL15 | Republican
2020 | Illinois | IL | IL16 | Republican
2020 | Illinois | IL | IL17 | Democrat
2020 | Illinois | IL | IL18 | Republican