Aravindnantha
New Member
- Joined
- Apr 27, 2019
- Messages
- 2
I Want to get Product value on below table using Excel formula
<tbody>
</tbody>Below is the source data, i have tried index match but i have duplicates on Name
<colgroup><col style="mso-width-source:userset;mso-width-alt:2669;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:2011;width:41pt" width="55"> <col style="mso-width-source:userset;mso-width-alt:1609;width:33pt" width="44"> </colgroup><tbody>
</tbody>
Kindly advise
<colgroup><col width="73"></colgroup><tbody> </tbody> |
<colgroup><col width="73"></colgroup><tbody> </tbody> |
<colgroup><col width="73"></colgroup><tbody> </tbody> | ||||
A | ||||||
B | ||||||
D |
<tbody>
</tbody>
Date | Product | Name |
01-01-2016 | 60 | A |
01-01-2016 | 54 | B |
01-01-2016 | 40 | C |
01-01-2016 | 60 | D |
01-03-2016 | 47 | A |
01-03-2016 | 39 | B |
01-03-2016 | 46 | C |
01-03-2016 | 42 | D |
01-02-2016 | 37 | A |
01-02-2016 | 53 | B |
01-02-2016 | 25 | C |
01-02-2016 | 46 | D |
01-04-2016 | 49 | A |
01-04-2016 | 47 | B |
01-04-2016 | 46 | C |
01-04-2016 | 27 | D |
<colgroup><col style="mso-width-source:userset;mso-width-alt:2669;width:55pt" width="73"> <col style="mso-width-source:userset;mso-width-alt:2011;width:41pt" width="55"> <col style="mso-width-source:userset;mso-width-alt:1609;width:33pt" width="44"> </colgroup><tbody>
</tbody>
Kindly advise