trustmeasfrnd
New Member
- Joined
- Oct 19, 2008
- Messages
- 32
hi,
how can i use formula by which when i input above valued it get in output Like for
MH1 in A1 its value 40 under A1 and 32 under A2 and 44 under A3. similarly for MH2 and so on but all Mh1 MH2 are variables.if there is no 2nd or 3rd Value it should show zero in A2 and A3.
i know its very easy but i am not able to do it using formula i am not sure how to vary range if i use index function.
how can i use formula by which when i input above valued it get in output Like for
MH1 in A1 its value 40 under A1 and 32 under A2 and 44 under A3. similarly for MH2 and so on but all Mh1 MH2 are variables.if there is no 2nd or 3rd Value it should show zero in A2 and A3.
i know its very easy but i am not able to do it using formula i am not sure how to vary range if i use index function.
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | Col A | Col B | COL C | ||||||
2 | MH1 | 65 | 40 | ||||||
3 | MH1 | 60 | 32 | ||||||
4 | MH1 | 40 | 44 | ||||||
5 | MH2 | 100 | 60 | ||||||
6 | MH2 | 80 | 48 | ||||||
7 | MH3 | 90 | 54 | ||||||
8 | MH4 | 110 | 66 | ||||||
9 | MH4 | 125 | 75 | ||||||
10 | MH5 | 55 | 33 | ||||||
11 | MH5 | 75 | 45 | ||||||
12 | MH5 | 85 | 51 | ||||||
13 | MH6 | 88 | 52.8 | ||||||
14 | MH7 | 69 | 41.4 | ||||||
15 | MH7 | 112 | 67.2 | ||||||
16 | |||||||||
17 | |||||||||
18 | OUTPUT | ||||||||
19 | S. No. | A1 | A2 | A3 | Summation | ||||
20 | 1 | MH1 | 0 | ||||||
21 | 2 | MH2 | 0 | ||||||
22 | 3 | MH3 | 0 | ||||||
23 | 4 | MH4 | 0 | ||||||
24 | 5 | MH5 | 0 | ||||||
25 | 6 | MH6 | 0 | ||||||
26 | 7 | MH7 | 0 | ||||||
27 | |||||||||
Sheet4 |