Calculate Percentage for matrix data

[rajamdade]

Below is the sample of data in matrix form (4000x4000), i need to find out percentage as shown:

GBCAT-1 GBCAT-2 GBCAT-3 GBCAT-4 GBCAT-5
GBCAT-1 0 0.226 0.234 0.216 0.248
GBCAT-2 0.226 0 0.235 0.208 0.194
GBCAT-3 0.234 0.235 0 0.21 0.249
GBCAT-4 0.216 0.208 0.21 0 0.195
GBCAT-5 0.248 0.194 0.249 0.195 0

% GBCAT-1 GBCAT-2 GBCAT-3 GBCAT-4 GBCAT-5
GBCAT-1 % % % % %
GBCAT-2 % % % % %
GBCAT-3 % % % % %
GBCAT-4 % % % % %
GBCAT-5 % % % % %


Please suggest formula or script, thank you!

[shg]

Welcome to the forum.

Please take a few minutes to read the forum rules (link in menu bar) about cross-posting.

Thanks.

[etaf]

percent of what ?

the total , the row , the column ?

you have 0 then 0.226 then 0.234
what do you want those to be the % of ?

[rajamdade]

Hi etaf! thanks for giving your time... percent of the total!

[etaf]

assuming you start in
B2
and the range was for example

B2:Z200

then the formula would be

B2/Sum($B$2:$Z$200)

and copy across and down

have you cross posted in another forum ?

rule 8 requires a link

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.