Formula modification for %

[Blake0920]

Trying to figure this one out.

I have this formula that segregates an "S" from this column but I am not too sure how to segregate the other options (O, R, E)

this is the formula to calculate the "S"
=SUMPRODUCT(SUBTOTAL(3,OFFSET(D4,ROW(D4:D53)-ROW(D4),0,1,1))*ISNUMBER(SEARCH(", "&TRANSPOSE(D7)&",",", "&D4:D53&",")))/SUMPRODUCT(SUBTOTAL(3,OFFSET(D4,ROW(D4:D53)-ROW(D4),0,1,1))*(LEN(D4:D53)-LEN(SUBSTITUTE(D4:D53,",",""))+(D4:D53<>"")))

Any ideas?

 

[Fluff]

Duplicate to: Separating values

Please stop posting the same question multiple times. Per Forum Rules (#12), post locked.