NapervilleMike
New Member
- Joined
- Aug 1, 2012
- Messages
- 19
So here is what I have:
<tbody>
</tbody>
What I need is a formula that will concatenate only the non-zero's and the substance associated with them. For example this out put should say: Water, 98; Sodium .5; Potassium, 1; Calcium .5
If this seems pointless, the reason I need a methodology because I actually have about 50 substances and there are about 30 "quantity" columns and I would like a nice way to automate this and apply it to other similar applications.
Thanks.
Substance | quantity |
Water | 98 |
Sodium | .5 |
Potassium | 1 |
Calcium | .5 |
Magnesium | 0 |
<tbody>
</tbody>
What I need is a formula that will concatenate only the non-zero's and the substance associated with them. For example this out put should say: Water, 98; Sodium .5; Potassium, 1; Calcium .5
If this seems pointless, the reason I need a methodology because I actually have about 50 substances and there are about 30 "quantity" columns and I would like a nice way to automate this and apply it to other similar applications.
Thanks.