Forum Discussion

porridge's avatar
porridge
Copper Contributor
Jul 31, 2022
Solved

excel table

Hello everyone. I am new here. I am currently learning excel and improving my skills.    I am currently working on a small college project, and I searched the internet but didn't get the answer I w...
excel
Macros and VBA
  • dscheikey's avatar
    dscheikey
    Jul 31, 2022

    Hiporridge, 

    I thought you wanted to do the assignment themselves as a school project. How many points will I get from the teacher? 🙂

    I have now added new formulas to the file. The result does not match the manual specifications, as there were already errors in here.

    I also tidied up so that no connected cells were left in the table.

    Have a look at it and see if it corresponds to your ideas.

     

porridge's avatar
porridge
Copper Contributor
Jul 31, 2022

mathetes 

 

In this 1st pic, I have the recipes down and sideways, then in the middle, I am trying to find the answer to that allergen that isn't common with the other recipe. For example, recipe 1 has milk and eggs only no mustard, so when I am cooking my next recipe 2 which consists of mustard and eggs, the answer I  should get in the middle cell should be milk only (because milk is not part of recipe 2) (But if I am going from recipe 2 to recipe 1, then the answer should change to the allergen mustard, as there's mustard in 2nd and not in 1st recipe) 

The 2nd pic is the data from which I have to get the answer. (only the 1st table in the pic should be considered)

I hope I was able to explain the situation clearly. :))

 

till then I would try the FILTER FUNCTION. 

dscheikey's avatar
dscheikey
Bronze Contributor
Jul 31, 2022

Hi porridge, 

I have tried to understand your problem. I also approached the matter with FILTER(). But I also need an auxiliary column (column "R") Please do not delete it. If you move it, the formulas have to be adjusted with INDIRECT(). Please have a look at it and see if it suits your needs.