Cell Follows Adjacent Cell

MrDB4Excel

Active Member
Joined
Jan 29, 2004
Messages
265
Office Version
  1. 2013
Platform
  1. Windows
How to Get a Value in a Cell to Follow Changes in Adjacent Columns
The content of this file is all about recipes and cooking, hopefully of interest to all who view this post. If anyone is interested in receiving any recipe seen I would be happy to share. If there is interest I can supply a listing of all recipes per any specific folder of your choosing. In addition to Tab #2 there are an additional 20 tabs containing recipes from the following types:
Bread-Muffin Recipes, Breakfast Recipes, Casserole Recipes, Chili-Soup-Stew Recipes, Conversion & How To, Dessert Recipes, Drinks, Egg Recipes, Health, Meat Recipes, Mexican Recipes, Misc Recipes, Oats-Rice-Potato Recipes, Pancake-Waffle Recipes, Peanut Butter, Pizza & Pasta Recipes, Salad Recipes, Sandwich Recipes, Sauce-Spread-Dip-Stuffing Recipes, and Vegetable Recipes
I am working on an xlsm file that Power Queries folder content of documents, PDFs, and Miscellaneous files, and links.
In column A is a file name, column G equals column A, and column H has the header of “Favorites?”, as in which recipes are favorites.
When new files are added in the relevant folder and the power query is refreshed, then any cell marked “Yes” does not follow the recipe name for which the “Yes” was entered in the first place.
What I would like to have happened is when new data enters the power query that any row that contained “Yes” in the H column prior to a refresh follows the recipe name to the new row.
I will provide 2 XL2bb Mini Sheets, the first showing a valid status regarding a specific recipe name coupled with a “Yes” value denoting the recipe is a favorite and the second showing what happens when a new document is added to the folder and power query is refreshed.
I have tinkered with this for the better part of half a day and can’t seem to hit on anything that remotely resembles what it takes to make it work. Note: the 2 instances of Yes have shifted to different recipe names. The first XL2bb Mini Sheet shows Yes for Spicy Hash Browns... and Yes for The best breakfast...; while the second XL2bb Mini Sheet shows Yes for Southwestern Hash with Eggs and Spicy Hash Browns...
Any help would be much appreciated.

CookingList.xlsm
ABEFGHIJKL
139F:\Data\Documents\Cooking\Breakfast Recipes\39TOC46
239F:\Data\Documents\Cooking\Breakfast Recipes39
378Breakfast Recipes -- Plus 3 SubFolders, See D1$I$43
4IndexFile NameHyperlinksDate ModifiedFile NameFavorite?File NameFavorite?
51Amish Breakfast Casserole.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Amish Breakfast Casserole.docx01/27/2019 03:04Amish Breakfast Casserole.docx1Amish Breakfast Casserole.docx
62As-You-Like-It Breakfast Casserole.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\As-You-Like-It Breakfast Casserole.docx04/22/2018 15:00As-You-Like-It Breakfast Casserole.docx2As-You-Like-It Breakfast Casserole.docx
73Best French Toast.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Best French Toast.docx03/17/2017 12:11Best French Toast.docx3Best French Toast.docx
84Broccoli Rabe and Sausage Scramble.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Broccoli Rabe and Sausage Scramble.docx05/05/2013 17:01Broccoli Rabe and Sausage Scramble.docx4Broccoli Rabe and Sausage Scramble.docx
95Chai Oatmeal.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Chai Oatmeal.docx03/03/2012 15:37Chai Oatmeal.docx5Chai Oatmeal.docx
106Cheesy Tater Tot Breakfast Bake.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Cheesy Tater Tot Breakfast Bake.docx04/22/2018 15:04Cheesy Tater Tot Breakfast Bake.docx6Cheesy Tater Tot Breakfast Bake.docx
117Clean Eating Slow Cooker Overnight Oatmeal.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Clean Eating Slow Cooker Overnight Oatmeal.docx06/29/2013 12:25Clean Eating Slow Cooker Overnight Oatmeal.docx7Clean Eating Slow Cooker Overnight Oatmeal.docx
128Country Style Spanish Potato Omelet.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Country Style Spanish Potato Omelet.docx07/13/2020 12:57Country Style Spanish Potato Omelet.docx8Country Style Spanish Potato Omelet.docx
139Crunchy Breakfast Wrap.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Crunchy Breakfast Wrap.docx11/03/2018 08:22Crunchy Breakfast Wrap.docx9Crunchy Breakfast Wrap.docx
1410Easy Breakfast Bake.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Easy Breakfast Bake.docx03/15/2015 12:31Easy Breakfast Bake.docx10Easy Breakfast Bake.docx
1511Easy One Pan Breakfast Skillet.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Easy One Pan Breakfast Skillet.docx12/22/2020 23:21Easy One Pan Breakfast Skillet.docx11Easy One Pan Breakfast Skillet.docx
1612Egg and Tater Bake.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Egg and Tater Bake.docx03/30/2018 21:49Egg and Tater Bake.docx12Egg and Tater Bake.docx
1713Everything Bagel Bombs.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Everything Bagel Bombs.docx04/22/2018 15:14Everything Bagel Bombs.docx13Everything Bagel Bombs.docx
1814Grape-Nuts.docF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Grape-Nuts.doc02/03/2012 16:33Grape-Nuts.doc14Grape-Nuts.doc
1915Ham and Cheese Breakfast Bake.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Ham and Cheese Breakfast Bake.docx03/30/2018 21:24Ham and Cheese Breakfast Bake.docx15Ham and Cheese Breakfast Bake.docx
2016Potato Omelet Stuffed with Ham and Cheese.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Potato Omelet Stuffed with Ham and Cheese.docx02/07/2020 05:17Potato Omelet Stuffed with Ham and Cheese.docx16Potato Omelet Stuffed with Ham and Cheese.docx
2117Sheepherderz Breakfast.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Sheepherderz Breakfast.docx02/23/2019 02:10Sheepherderz Breakfast.docx17Sheepherderz Breakfast.docx
2218Shepherdz Inn Breakfast Pie.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Shepherdz Inn Breakfast Pie.docx02/23/2019 02:09Shepherdz Inn Breakfast Pie.docx18Shepherdz Inn Breakfast Pie.docx
2319Southwestern Hash with Eggs.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Southwestern Hash with Eggs.docx03/23/2019 22:31Southwestern Hash with Eggs.docx19Southwestern Hash with Eggs.docx
2420Spicy Hash Browns For Breakfast.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Spicy Hash Browns For Breakfast.docx06/07/2020 23:43Spicy Hash Browns For Breakfast.docxYes20Spicy Hash Browns For Breakfast.docxYes
2521The best breakfast for weight loss recipes.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\The best breakfast for weight loss recipes.docx12/03/2021 09:54The best breakfast for weight loss recipes.docxYes21The best breakfast for weight loss recipes.docxYes
2622The Ultimate Roasted Potato-Egg Breakfast Skillet.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\The Ultimate Roasted Potato-Egg Breakfast Skillet.docx04/11/2021 13:13The Ultimate Roasted Potato-Egg Breakfast Skillet.docx22The Ultimate Roasted Potato-Egg Breakfast Skillet.docx
2723Bake-Broil 2.jpgF:\Data\Documents\Cooking\Breakfast Recipes\Misc\Bake-Broil 2.jpg04/11/2021 13:11Bake-Broil 2.jpg23Bake-Broil 2.jpg
2824Bake-Broil.jpgF:\Data\Documents\Cooking\Breakfast Recipes\Misc\Bake-Broil.jpg04/11/2021 13:07Bake-Broil.jpg24Bake-Broil.jpg
2925Breakfast Egg Rolls Air Fryer.urlF:\Data\Documents\Cooking\Breakfast Recipes\Misc\Breakfast Egg Rolls Air Fryer.url02/17/2020 11:58Breakfast Egg Rolls Air Fryer.url25Breakfast Egg Rolls Air Fryer.url
3026Tasty Spanish potato omelette SANDWICH.urlF:\Data\Documents\Cooking\Breakfast Recipes\Misc\Tasty Spanish potato omelette SANDWICH.url01/26/2020 23:47Tasty Spanish potato omelette SANDWICH.url26Tasty Spanish potato omelette SANDWICH.url
31275 Ingredient Sausage Hash Brown Casserole.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\5 Ingredient Sausage Hash Brown Casserole.pdf12/13/2017 04:065 Ingredient Sausage Hash Brown Casserole.pdf275 Ingredient Sausage Hash Brown Casserole.pdf
3228Cracked Out Tater Tot Breakfast Casserole.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Cracked Out Tater Tot Breakfast Casserole.pdf12/13/2017 04:05Cracked Out Tater Tot Breakfast Casserole.pdf28Cracked Out Tater Tot Breakfast Casserole.pdf
3329Crunchy Breakfast Wrap.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Crunchy Breakfast Wrap.pdf11/03/2018 08:22Crunchy Breakfast Wrap.pdf29Crunchy Breakfast Wrap.pdf
3430Eggsquisite Breakfast Casserole.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Eggsquisite Breakfast Casserole.pdf12/05/2017 04:10Eggsquisite Breakfast Casserole.pdf30Eggsquisite Breakfast Casserole.pdf
3531Green Chile And Tomato Egg Casserole.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Green Chile And Tomato Egg Casserole.pdf12/13/2017 04:08Green Chile And Tomato Egg Casserole.pdf31Green Chile And Tomato Egg Casserole.pdf
3632No-Turn Omelet.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\No-Turn Omelet.pdf12/13/2017 04:00No-Turn Omelet.pdf32No-Turn Omelet.pdf
3733One-Pot Spicy Eggs and Potatoes.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\One-Pot Spicy Eggs and Potatoes.pdf08/25/2016 22:48One-Pot Spicy Eggs and Potatoes.pdf33One-Pot Spicy Eggs and Potatoes.pdf
3834Overnight Breakfast Casserole.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Overnight Breakfast Casserole.pdf08/25/2016 11:28Overnight Breakfast Casserole.pdf34Overnight Breakfast Casserole.pdf
3935OvernightOatmealRecipe.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\OvernightOatmealRecipe.pdf11/04/2016 19:01OvernightOatmealRecipe.pdf35OvernightOatmealRecipe.pdf
4036Pumpkin Spice Oatmeal.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Pumpkin Spice Oatmeal.pdf12/13/2017 03:59Pumpkin Spice Oatmeal.pdf36Pumpkin Spice Oatmeal.pdf
4137Sausage, Egg and Cheddar Farmer's Breakfast.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Sausage, Egg and Cheddar Farmer's Breakfast.pdf12/05/2017 04:01Sausage, Egg and Cheddar Farmer's Breakfast.pdf37Sausage, Egg and Cheddar Farmer's Breakfast.pdf
4238Slow Cooker Easy Breakfast Casserole.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Slow Cooker Easy Breakfast Casserole.pdf08/25/2016 11:29Slow Cooker Easy Breakfast Casserole.pdf38Slow Cooker Easy Breakfast Casserole.pdf
4339The Ultimate Breakfast Skillet with Roasted Potatoes and Eggs.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\The Ultimate Breakfast Skillet with Roasted Potatoes and Eggs.pdf07/05/2020 07:29The Ultimate Breakfast Skillet with Roasted Potatoes and Eggs.pdf39The Ultimate Breakfast Skillet with Roasted Potatoes and Eggs.pdf
44??????
45??????
46??????
2
Cell Formulas
RangeFormula
A1A1=COUNT(INDIRECT("H5:"&E3))
B1B1=LEFT(C5,LEN(C5)-5)
A2A2=SUMPRODUCT(--NOT(ISNUMBER(INDIRECT("H5:"&E3))))
B2B2=MID(B1,1,43)
J1J1=SUMPRODUCT(MAX((I:I<>"")*ROW(I:I)))
A3A3=SUM(A1:A2)
B3B3=RIGHT(B2,LEN(B2)-26)&" -- Plus 3 SubFolders, See D1"
E1E1=COUNT(I:I)
E2E2=MAX(I:I)
E3E3=CELL("address",INDEX(I:I,MATCH(MAX(I:I),I:I,0)))
A5:A46A5=IFERROR(VLOOKUP('pq2'!$A5,'pq2'!$A:$A,COLUMN('pq2'!$A:$A)-COLUMN('pq2'!$A:$A)+1,0),"?")
B5:B46B5=IFERROR(VLOOKUP('pq2'!$B5,'pq2'!$B:$B,COLUMN('pq2'!$B:$B)-COLUMN('pq2'!$B:$B)+1,0),"?")
E5:E46E5=HYPERLINK(D5)
F5:F46F5=IFERROR(VLOOKUP('pq2'!$D5,'pq2'!$D:$D,COLUMN('pq2'!$D:$D)-COLUMN('pq2'!$D:$D)+1,0),"?")
G5:G43G5=B5
I5:I46I5=A5
Named Ranges
NameRefers ToCells
'pq2'!ExternalData_1='pq2'!$A$4:$D$43A5:A46


CookingList.xlsm
ABEFGHIJKL
139F:\Data\Documents\Cooking\Breakfast Recipes\39TOC46
239F:\Data\Documents\Cooking\Breakfast Recipes40
378Breakfast Recipes -- Plus 3 SubFolders, See D1$I$43
4IndexFile NameHyperlinksDate ModifiedFile NameFavorite?File NameFavorite?
51Amish Breakfast Casserole.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Amish Breakfast Casserole.docx01/27/2019 03:04Amish Breakfast Casserole.docx1Amish Breakfast Casserole.docx
62As-You-Like-It Breakfast Casserole - Copy.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\As-You-Like-It Breakfast Casserole - Copy.docx04/22/2018 15:00As-You-Like-It Breakfast Casserole - Copy.docx2As-You-Like-It Breakfast Casserole.docx
73As-You-Like-It Breakfast Casserole.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\As-You-Like-It Breakfast Casserole.docx04/22/2018 15:00As-You-Like-It Breakfast Casserole.docx3Best French Toast.docx
84Best French Toast.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Best French Toast.docx03/17/2017 12:11Best French Toast.docx4Broccoli Rabe and Sausage Scramble.docx
95Broccoli Rabe and Sausage Scramble.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Broccoli Rabe and Sausage Scramble.docx05/05/2013 17:01Broccoli Rabe and Sausage Scramble.docx5Chai Oatmeal.docx
106Chai Oatmeal.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Chai Oatmeal.docx03/03/2012 15:37Chai Oatmeal.docx6Cheesy Tater Tot Breakfast Bake.docx
117Cheesy Tater Tot Breakfast Bake.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Cheesy Tater Tot Breakfast Bake.docx04/22/2018 15:04Cheesy Tater Tot Breakfast Bake.docx7Clean Eating Slow Cooker Overnight Oatmeal.docx
128Clean Eating Slow Cooker Overnight Oatmeal.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Clean Eating Slow Cooker Overnight Oatmeal.docx06/29/2013 12:25Clean Eating Slow Cooker Overnight Oatmeal.docx8Country Style Spanish Potato Omelet.docx
139Country Style Spanish Potato Omelet.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Country Style Spanish Potato Omelet.docx07/13/2020 12:57Country Style Spanish Potato Omelet.docx9Crunchy Breakfast Wrap.docx
1410Crunchy Breakfast Wrap.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Crunchy Breakfast Wrap.docx11/03/2018 08:22Crunchy Breakfast Wrap.docx10Easy Breakfast Bake.docx
1511Easy Breakfast Bake.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Easy Breakfast Bake.docx03/15/2015 12:31Easy Breakfast Bake.docx11Easy One Pan Breakfast Skillet.docx
1612Easy One Pan Breakfast Skillet.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Easy One Pan Breakfast Skillet.docx12/22/2020 23:21Easy One Pan Breakfast Skillet.docx12Egg and Tater Bake.docx
1713Egg and Tater Bake.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Egg and Tater Bake.docx03/30/2018 21:49Egg and Tater Bake.docx13Everything Bagel Bombs.docx
1814Everything Bagel Bombs.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Everything Bagel Bombs.docx04/22/2018 15:14Everything Bagel Bombs.docx14Grape-Nuts.doc
1915Grape-Nuts.docF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Grape-Nuts.doc02/03/2012 16:33Grape-Nuts.doc15Ham and Cheese Breakfast Bake.docx
2016Ham and Cheese Breakfast Bake.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Ham and Cheese Breakfast Bake.docx03/30/2018 21:24Ham and Cheese Breakfast Bake.docx16Potato Omelet Stuffed with Ham and Cheese.docx
2117Potato Omelet Stuffed with Ham and Cheese.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Potato Omelet Stuffed with Ham and Cheese.docx02/07/2020 05:17Potato Omelet Stuffed with Ham and Cheese.docx17Sheepherderz Breakfast.docx
2218Sheepherderz Breakfast.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Sheepherderz Breakfast.docx02/23/2019 02:10Sheepherderz Breakfast.docx18Shepherdz Inn Breakfast Pie.docx
2319Shepherdz Inn Breakfast Pie.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Shepherdz Inn Breakfast Pie.docx02/23/2019 02:09Shepherdz Inn Breakfast Pie.docx19Southwestern Hash with Eggs.docx
2420Southwestern Hash with Eggs.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Southwestern Hash with Eggs.docx03/23/2019 22:31Southwestern Hash with Eggs.docxYes20Spicy Hash Browns For Breakfast.docxYes
2521Spicy Hash Browns For Breakfast.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\Spicy Hash Browns For Breakfast.docx06/07/2020 23:43Spicy Hash Browns For Breakfast.docxYes21The best breakfast for weight loss recipes.docxYes
2622The best breakfast for weight loss recipes.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\The best breakfast for weight loss recipes.docx12/03/2021 09:54The best breakfast for weight loss recipes.docx22The Ultimate Roasted Potato-Egg Breakfast Skillet.docx
2723The Ultimate Roasted Potato-Egg Breakfast Skillet.docxF:\Data\Documents\Cooking\Breakfast Recipes\Docs\The Ultimate Roasted Potato-Egg Breakfast Skillet.docx04/11/2021 13:13The Ultimate Roasted Potato-Egg Breakfast Skillet.docx23Bake-Broil 2.jpg
2824Bake-Broil 2.jpgF:\Data\Documents\Cooking\Breakfast Recipes\Misc\Bake-Broil 2.jpg04/11/2021 13:11Bake-Broil 2.jpg24Bake-Broil.jpg
2925Bake-Broil.jpgF:\Data\Documents\Cooking\Breakfast Recipes\Misc\Bake-Broil.jpg04/11/2021 13:07Bake-Broil.jpg25Breakfast Egg Rolls Air Fryer.url
3026Breakfast Egg Rolls Air Fryer.urlF:\Data\Documents\Cooking\Breakfast Recipes\Misc\Breakfast Egg Rolls Air Fryer.url02/17/2020 11:58Breakfast Egg Rolls Air Fryer.url26Tasty Spanish potato omelette SANDWICH.url
3127Tasty Spanish potato omelette SANDWICH.urlF:\Data\Documents\Cooking\Breakfast Recipes\Misc\Tasty Spanish potato omelette SANDWICH.url01/26/2020 23:47Tasty Spanish potato omelette SANDWICH.url275 Ingredient Sausage Hash Brown Casserole.pdf
32285 Ingredient Sausage Hash Brown Casserole.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\5 Ingredient Sausage Hash Brown Casserole.pdf12/13/2017 04:065 Ingredient Sausage Hash Brown Casserole.pdf28Cracked Out Tater Tot Breakfast Casserole.pdf
3329Cracked Out Tater Tot Breakfast Casserole.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Cracked Out Tater Tot Breakfast Casserole.pdf12/13/2017 04:05Cracked Out Tater Tot Breakfast Casserole.pdf29Crunchy Breakfast Wrap.pdf
3430Crunchy Breakfast Wrap.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Crunchy Breakfast Wrap.pdf11/03/2018 08:22Crunchy Breakfast Wrap.pdf30Eggsquisite Breakfast Casserole.pdf
3531Eggsquisite Breakfast Casserole.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Eggsquisite Breakfast Casserole.pdf12/05/2017 04:10Eggsquisite Breakfast Casserole.pdf31Green Chile And Tomato Egg Casserole.pdf
3632Green Chile And Tomato Egg Casserole.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Green Chile And Tomato Egg Casserole.pdf12/13/2017 04:08Green Chile And Tomato Egg Casserole.pdf32No-Turn Omelet.pdf
3733No-Turn Omelet.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\No-Turn Omelet.pdf12/13/2017 04:00No-Turn Omelet.pdf33One-Pot Spicy Eggs and Potatoes.pdf
3834One-Pot Spicy Eggs and Potatoes.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\One-Pot Spicy Eggs and Potatoes.pdf08/25/2016 22:48One-Pot Spicy Eggs and Potatoes.pdf34Overnight Breakfast Casserole.pdf
3935Overnight Breakfast Casserole.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Overnight Breakfast Casserole.pdf08/25/2016 11:28Overnight Breakfast Casserole.pdf35OvernightOatmealRecipe.pdf
4036OvernightOatmealRecipe.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\OvernightOatmealRecipe.pdf11/04/2016 19:01OvernightOatmealRecipe.pdf36Pumpkin Spice Oatmeal.pdf
4137Pumpkin Spice Oatmeal.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Pumpkin Spice Oatmeal.pdf12/13/2017 03:59Pumpkin Spice Oatmeal.pdf37Sausage, Egg and Cheddar Farmer's Breakfast.pdf
4238Sausage, Egg and Cheddar Farmer's Breakfast.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\Sausage, Egg and Cheddar Farmer's Breakfast.pdf12/05/2017 04:01Sausage, Egg and Cheddar Farmer's Breakfast.pdf38Slow Cooker Easy Breakfast Casserole.pdf
4340The Ultimate Breakfast Skillet with Roasted Potatoes and Eggs.pdfF:\Data\Documents\Cooking\Breakfast Recipes\PDFs\The Ultimate Breakfast Skillet with Roasted Potatoes and Eggs.pdf07/05/2020 07:29The Ultimate Breakfast Skillet with Roasted Potatoes and Eggs.pdf40The Ultimate Breakfast Skillet with Roasted Potatoes and Eggs.pdf
44??????
45??????
46??????
2
Cell Formulas
RangeFormula
A1A1=COUNT(INDIRECT("H5:"&E3))
B1B1=LEFT(C5,LEN(C5)-5)
A2A2=SUMPRODUCT(--NOT(ISNUMBER(INDIRECT("H5:"&E3))))
B2B2=MID(B1,1,43)
J1J1=SUMPRODUCT(MAX((I:I<>"")*ROW(I:I)))
A3A3=SUM(A1:A2)
B3B3=RIGHT(B2,LEN(B2)-26)&" -- Plus 3 SubFolders, See D1"
E1E1=COUNT(I:I)
E2E2=MAX(I:I)
E3E3=CELL("address",INDEX(I:I,MATCH(MAX(I:I),I:I,0)))
A5:A42A5=IFERROR(VLOOKUP('pq2'!$A5,'pq2'!$A:$A,COLUMN('pq2'!$A:$A)-COLUMN('pq2'!$A:$A)+1,0),"?")
B5:B42B5=IFERROR(VLOOKUP('pq2'!$B5,'pq2'!$B:$B,COLUMN('pq2'!$B:$B)-COLUMN('pq2'!$B:$B)+1,0),"?")
E5:E46E5=HYPERLINK(D5)
F5:F42F5=IFERROR(VLOOKUP('pq2'!$D5,'pq2'!$D:$D,COLUMN('pq2'!$D:$D)-COLUMN('pq2'!$D:$D)+1,0),"?")
G5:G43G5=B5
A43:A46A43=IFERROR(VLOOKUP('pq2'!$A44,'pq2'!$A:$A,COLUMN('pq2'!$A:$A)-COLUMN('pq2'!$A:$A)+1,0),"?")
B43:B46B43=IFERROR(VLOOKUP('pq2'!$B44,'pq2'!$B:$B,COLUMN('pq2'!$B:$B)-COLUMN('pq2'!$B:$B)+1,0),"?")
F43:F46F43=IFERROR(VLOOKUP('pq2'!$D44,'pq2'!$D:$D,COLUMN('pq2'!$D:$D)-COLUMN('pq2'!$D:$D)+1,0),"?")
I5:I46I5=A5
Named Ranges
NameRefers ToCells
'pq2'!ExternalData_1='pq2'!$A$4:$D$44A5:A46
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,175,859
Messages
5,899,909
Members
434,805
Latest member
Nihon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top