if i have the following columa

aa 111
bb 222
aa
cc 333
dd 444
aa
aa 321
cc
cc

from above if it huag data and i want ensuar that all aa have same key
account whuch 111 and other key account and if aa has more than one key
account it show wrong or any thing like B7 it has wrong key which 321
how i cank make it by excel

Hi,

5 is what percent of 13?

=5/13

then format as a percent - Format, Cells, Number tab, Percent or click the %
button on the toolbar.

A decimal can be converted to a percent by formatting in Excel. or on paper
by multiplying by 100. 0.05 = 100*(0.05) = 5%

In Excel you don't do both formatting and multiplying by 100, it depends on
what you actually need/want.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"M.K" wrote:

if i have the following columa

aa 111
bb 222
aa
cc 333
dd 444
aa
aa 321
cc
cc

from above if it huag data and i want ensuar that all aa have same key
account whuch 111 and other key account and if aa has more than one key
account it show wrong or any thing like B7 it has wrong key which 321
how i cank make it by excel

Hi,

Sorry this was intended for another post.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Shane Devenshire" wrote:

Hi,

5 is what percent of 13?

=5/13

then format as a percent - Format, Cells, Number tab, Percent or click the %
button on the toolbar.

A decimal can be converted to a percent by formatting in Excel. or on paper
by multiplying by 100. 0.05 = 100*(0.05) = 5%

In Excel you don't do both formatting and multiplying by 100, it depends on
what you actually need/want.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"M.K" wrote:

if i have the following columa

aa 111
bb 222
aa
cc 333
dd 444
aa
aa 321
cc
cc

from above if it huag data and i want ensuar that all aa have same key
account whuch 111 and other key account and if aa has more than one key
account it show wrong or any thing like B7 it has wrong key which 321
how i cank make it by excel