I have a spreadsheet where I am trying to find the majority party until the the state value changes in the row. I have included a sample of my spreadsheet that I am working in, which also includes my novice attempt at the formula. So in essence I am trying to populate the majority party of each individual state. Any assistance is appreciated in advance!
House_Sample.xlsx
Bookmarks