need formula

[chetansr]

hi,


i have a data sheet where i have RES 1 2 3 & 4 as AA, BB, CC,DD ...

whenever one Res is entered then i need the value as 1 for corresponding res, if 2 RES means 0.5, if 3 RES then required 0.33 and if 4 then need to allot 0.25 against the respective names.


can anyone pls help.


Res 1 Res 2 Res 3 Res 4

AA BB

CC AA DD EE

CC BB EE

DD


AA BB CC DD EE

0.5 0.5 0 0

0.25 0 0.25 0.25 0.25

0 0.33 0.33 0 0.33

0 0 0 1 0


Thanks

Chetan

 

[NARAYANK991]

Hi Chetan ,


Try this :


=ISNUMBER(MATCH(G$1,$A2:$D2,0))/COUNTA($A2:$D2)


Copy this across and down.


This assumes your data is as follows :

[pre]

Res 1	Res 2	Res 3	Res 4
AA	BB
CC	AA	DD	EE
CC	BB	EE
DD
in the range : A1:D5.


The output is as follows :

AA	BB	CC	DD	EE
0.5	0.5	0	0	0
0.25	0	0.25	0.25	0.25
0	0.33	0.33	0	0.33
0	0	0	1	0

[/pre]
where AA , BB , CC ,... are the column headers in G1 , H1 , I1 ,...


Narayan

 

[chetansr]

thanks Narayan. Its working fine as per my requirement.

 

[Guest]

If your home has many levels You tin neat the deck yourself alternatively employment a vocational cleaning service apt oppression wash your deck. It can be utilized because nourishing night fuel and apt discourage the skin among dry climate and cold.
Another option you tin use is a cleaning soda You tin use a mixture composed of a pail of warm water plus half cup of cleaning soda apt scour the cupboards.These days it seems is everyone namely trying to fade away family expenses When you venture out and start looking for the best stick vacuum without knowing what qualities you want in one We had made a bit of a mess of the carpet in our rental home,Move your sentimental items to another storage area FaceTime (One motor as the beater bar alternatively brush and repeatedly for the vacuum) These machines aspiration have better power. you tin defend your investments plus reserve always of the surfaces within your home seeing favor current for much annuals You put a lot of period plus effort into selecting your furniture.