need formula for % of times text appears in row.
Hi. I need help with with calculating the percentage of times
a specific text appears within a row.
The formula needs to be relative, so I can copy and paste it
into successive rows.
e.g. Based on the text in A2:D2, what are the percentages
for x, y, z in that range?
____________________________________
__ |_A_|_B_|_C_|_D_| _E_ |__F_ |_ G_ |__
1 | | | | | %x | %y | %z |
2 | z | y | z | x | 25 | 25 | 50 |
_____________________________________
(Thus, row 2 is comprised of 25% X, 25% Y, 50% Z.
Can someone help me with this?)
Thank you,
Bob
|