Hi everyone,
I'm new here, please bear with me. I have a chart (see attached image for a made-up example) in which the rows are ingredients and the columns are different soil types. What I need to do is to automatically generate "recipes" for each soil type by showing only the ingredients for which a soil type has a nonzero value, and next to that, their values (the second attachment is what I'd like it to look like).
I think I need to use some sort of array formula, but I'm not totally sure what that is, and I definitely don't know how to write one.
Please help! Thank you in advance for your time/expertise.
Bookmarks