Difficult Question inside! Anyone up for it?

[Healingbear]

I have only been using Excel for a month now, but did some programmin
many years ago. Maybe I’m being too aggressive, but I’m trying t
divide bills by the number of people responsible for them.

D3=$10.00
E4= PB, RC, GF

D E F G
H I
1 PB RC GF BEV
2 Amount Description $30.00 $30.00 $30.00 $30.00
3 $10.00 Lunch $3.23 $3.23 $3.24
4 PB, RC, GF $26.77 $26.77 $26.76 $30.00
5 $5.50 Bowling
6 PR, RS $26.77 $26.77 $26.76 $30.00
7 $25.00 Birthday Gift
KG $26.77 $26.77 $26.76 $30.00

F3=ROUNDDOWN(($D$3)/(LEN(E4)-LEN(SUBSTITUTE(E4,",",""))+1),2) = $3.23
G3=ROUNDDOWN(($D$3)/(LEN(E4)-LEN(SUBSTITUTE(E4,",",""))+1),2) = $3.23
H3=ROUNDUP(($D$3)/(LEN(E4)-LEN(SUBSTITUTE(E4,",",""))+1),2) = $3.24

While the formulas look tedious, they do work. The more difficul
question is:
What if there were 4 initials in cell E4?
Is there anyway to automatically divide the amount spent by the numbe
of people responsible and place their portion of the bill in thei
respective column and row?
If it can be done, can it be assigned to a button, where after enterin
the amount and initials, the button can assign the bill portions to th
appropriate cells?
I apologize for a newbie asking such an apparently intensive question.
Don’t be afraid to tell me where to go! ;-) I’m loving learning th
power of excel!


Thanks in advance for help and/or insults! ;-)

Healingbea

 

[Healingbear]

To all who attempt to help me, I apologize for how my sheet portio
looks. It lost the formatting when I posted the thread. I'm trying t
figure out how to post an actual sheet portion.

Healingbea