Sorry Frank I wasnt sure if you would have checked back on
this one with the thread getting to long

**

Your suggestion would work but sometimes the data is as
follows. as you can see sometimes the person has got
three types of IDs and they are relational to the value
next to them (always the cell to the right) of the ID.
How can I get round this?

A B C D E F G
1 name1 555 25 666 50 777 25
2 name2 666 50 555 50 - -
3 name2 555 70 - - - -
.....

Name 1 has a total of 100 (C+E+G) and 555 and 666 IDs are
type A. 777 is type B then for name a type A % = 75% and
type B % = 25%.

Name 2 has a total of 100 also but as both IDs are type
A ......

I hope that explains it better

Thanks again