Don't know what you call this, but here goes...
This ones a little tricky, to me atleast. The display comlumn will be
empty. When the data under D,L,W,S is inputted i need it to the display
the formula (Disp.). It would be really nice to be able to group any (D
W L S) that have the same value aswell. I'm thinking that's the tricky
part.

Here's my table, it is not limited to 2 rows.

Disp. D L W S
D+.5(L+W) 1 0.5 0.5 0
D+.5L+S 1 0.5 0 1

Any suggestions on how to approch it? This will be on a Worksheet
Change event that much I can do, just not the rest.

Cheers.
Kevin.