Forum Discussion
excel table
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.
dscheikey https://docs.google.com/spreadsheets/d/1PVcqYU_Zq23ARjiNtALBSLGqOdA-nvY5/edit?usp=sharing&ouid=115161584172678082193&rtpof=true&sd=true
The file you shared it is good when I am going from recipe 1 to 2 to 3 to 4 and so on.
I have attached the XLSX link to my file.
In my previous reply, I mentioned that when I am going from 1 to 2 the answer will be xyz, and then when am going back to 2 to 1, the answer will be different as the allergens present in both the recipes are different. And also there are recipes where they have the same allergens so the answer ends up being NA due to the same allergens.
you can go through my xlsx file to understand the data available. i have written the answers for the 1st 5 recipes manually so it gives an idea. the 2nd sheet in the file is the reference file. :))
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.
OMG!!. you didn't have to solve it entirely... I am speechless at what amazing work you have done. I was trying to figure out this for so many days. The file looked so perfectly well done. I went through it and it gives me the perfect idea of how to carry out the work.
Dear Excel wizard, can you please guide me on how to achieve this level of excel!!! I am still a novice. going through the trial and error method :)))Thank you so much for your help. And yes you get a full grade for this assignment. without a doubt!!!