Hello all,
I am having some trouble combining two find functions. Attached is a sample excel file that I am working in.
You will see that Column A is the recipes I am working with.
Column B states what meal of the day these recipes will be eaten. (B=breakfast, L=lunch, D=dinner).
Column C states which days of the week these recipes will be eaten. (1=Monday or Day 1, 2=Tuesday or Day 2, etc).
In the top table, Row 2 shows the formula that I was working with by just sorting the recipes by the day number. For instance, all recipes that I inserted a "1" beside would appear in F2. All recipes that I inserted a "3" beside would appear in H2.
In the bottom table, I show you essentially the same formula as the table above, yet by searching for the corresponding meal time (B,L, or D) and this populates the table with recipes that contain the corresponding meal time.
What I am trying to do is combine both of these into one function. The green text that I manually input in the top table is what I would like it to look like. Here, it first sorts by the meal time (B,L,D), and then by the day number (1,2,3,4,5,6,7).
Your help is greatly appreciated!!
Bookmarks