I am trying to determine what my dog is allergic to by analyzing ingredients in foods she did and didn't have an allergic reaction to. I organized the data into a tab with all of the "Good" foods, one with the "Bad" foods, an "Analysis" tab which counts how many times each "Bad" ingredient appears on the "Good" tab and gives each ingredient a weighted value, and a "Results" tab which lists only "Bad" ingredients that are not on the "Good" tab (count of 0). The problem is my "Results" list is pulling the ingredient below the 0 count ingredient. My formula is below and the sheet is attached.
{=IFERROR(INDEX(Bad!A$2:A$70,SMALL(IF(Analysis!A$2:A$70=0,ROW(Bad!A$2:A$70)),ROWS(A$2:A2))),"")}
I was trying to pull a list of ingredients that are in each of the "Bad" foods that do not appear on the "Good" tab at all without the interim "Analysis" tab, but couldn't wrap my head around a formula. So if anyone thinks that is an easier solution, I'm all ears.
Thanks in advance for any help.
Bookmarks