In article ,
"Karl Burrows" wrote:

Problem is I don't have a column of named builders like you have in D2:D10.

I should have said, 'enter a list of builders in D2:D10', as described.
So with the list of builders you've now provided, enter the following
list in D2:D13...

Beazer
C.P. Morgan
D.R. Horton
KB
Lennar
McCar
Mulvaney
Pulte
Ryan
Saussy
Unsold
Westminster

....and change the references in the formula accordingly. Does this help?