excelzunder
New Member
- Joined
- Apr 10, 2018
- Messages
- 1
Hello,
I need to complete the table but I'm not sure how to write the formula in this case.
Could you please advise.
Chart A: original data
<tbody>
</tbody>
Chart B: I need to complete "Store" column by formula
<tbody>
</tbody>
Thank you!
I need to complete the table but I'm not sure how to write the formula in this case.
Could you please advise.
Chart A: original data
Project | Product | Store |
1973 | A | Store1 |
1973 | B | Store2 |
1973 | A | Store1 |
1973 | C | Store3 |
1973 | A | Store1 |
2233 | A | Store1 |
2233 | B | Store2 |
2233 | A | Store1 |
<tbody>
</tbody>
Chart B: I need to complete "Store" column by formula
Project | Product | Store |
1973 | A | ??? |
1973 | B | ??? |
1973 | A | ??? |
1973 | C | ??? |
2233 | A | ??? |
2233 | C | ??? |
<tbody>
</tbody>
Thank you!