Spreadsheet: 806100d1669108948-how-to-find-the-majority-value-of-a-column-until-a-value-changes-in-another-column-house_example-tms
Sheet: Sheet1

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