fireboltpk
New Member
- Joined
- May 29, 2017
- Messages
- 9
Hi,
I have a data set with 600 products where I need to pickup the value that is greater than zero. Below is an example of my data set and what I need to pick.
<tbody>
</tbody>
What I basically want is that when I do a lookup for Coke and Fanta, my return values are 7 and 5.
Regards,
M
I have a data set with 600 products where I need to pickup the value that is greater than zero. Below is an example of my data set and what I need to pick.
Product | Price |
Coke | 0 |
Coke | 0 |
Coke | 0 |
Coke | 7 |
Fanta | 0 |
Fanta | 5 |
Fanta | 0 |
<tbody>
</tbody>
What I basically want is that when I do a lookup for Coke and Fanta, my return values are 7 and 5.
Regards,
M