Stan_C
Active Member
- Joined
- Feb 10, 2012
- Messages
- 353
I came up with a formula for this and I am probably over thinking this but, it fails about 500 cells down.
Col. (A) I have Item data that are names: Col. (B) I have data but would like b1=a1, b16=a2, b31=a3
So with column (B) +15 rows to = (A) +1
[TABLE="width: 513"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]2% Milk[/TD]
[TD]2% Milk[/TD]
[/TR]
[TR]
[TD]Ambrosia[/TD]
[TD]Regular [/TD]
[/TR]
[TR]
[TD]American Chop Suey[/TD]
[TD]3-4gm Na (NAS)[/TD]
[/TR]
[TR]
[TD]Apple Pie[/TD]
[TD]2gm Na[/TD]
[/TR]
[TR]
[TD]Bacon Strip[/TD]
[TD]Low Fat/Low Chol[/TD]
[/TR]
[TR]
[TD]Baked Beans[/TD]
[TD]Fiber Restricted[/TD]
[/TR]
[TR]
[TD]Baked Chicken Breast[/TD]
[TD]Consistent Carb[/TD]
[/TR]
[TR]
[TD]Baked Ham Pineapple Sauce[/TD]
[TD]Cardiac Diabetic[/TD]
[/TR]
[TR]
[TD]BBQ Pork on Bun[/TD]
[TD]2 gm K[/TD]
[/TR]
[TR]
[TD]Beef Barley & Veg Soup[/TD]
[TD]Lactose Restricted[/TD]
[/TR]
[TR]
[TD]Beef Lasagna[/TD]
[TD]Vegetarian LactoOvo[/TD]
[/TR]
[TR]
[TD]Beef Liver & Onions[/TD]
[TD]Gluten Restricted[/TD]
[/TR]
[TR]
[TD]Braised Cabbage[/TD]
[TD]Renal CSC[/TD]
[/TR]
[TR]
[TD]Bread Pudding[/TD]
[TD]Small Portion[/TD]
[/TR]
[TR]
[TD]Broccoli[/TD]
[TD]Large Portion[/TD]
[/TR]
[TR]
[TD]Broccoli & Cheese Quiche[/TD]
[TD]Ambrosia[/TD]
[/TR]
[TR]
[TD]Brown Bread[/TD]
[TD]Regular [/TD]
[/TR]
[TR]
[TD]Brownie[/TD]
[TD]3-4gm Na (NAS)[/TD]
[/TR]
[TR]
[TD]Brussels Sprouts[/TD]
[TD]2gm Na[/TD]
[/TR]
[TR]
[TD]Carnival Cake[/TD]
[TD]Low Fat/Low Chol[/TD]
[/TR]
[TR]
[TD]Carrot Bisque[/TD]
[TD]Fiber Restricted[/TD]
[/TR]
[TR]
[TD]Carrot Raisin Salad[/TD]
[TD]Consistent Carb[/TD]
[/TR]
[TR]
[TD]Cheese Omelet[/TD]
[TD]Cardiac Diabetic[/TD]
[/TR]
[TR]
[TD]Chicken Patty[/TD]
[TD]2 gm K[/TD]
[/TR]
[TR]
[TD]Chicken Rice Soup[/TD]
[TD]Lactose Restricted[/TD]
[/TR]
[TR]
[TD]Chicken Tenders[/TD]
[TD]Vegetarian LactoOvo[/TD]
[/TR]
[TR]
[TD]Chilled Pineapple[/TD]
[TD]Gluten Restricted[/TD]
[/TR]
[TR]
[TD]Cole Slaw[/TD]
[TD]Renal CSC[/TD]
[/TR]
[TR]
[TD]Coleslaw[/TD]
[TD]Small Portion[/TD]
[/TR]
[TR]
[TD]Cornbread[/TD]
[TD]Large Portion[/TD]
[/TR]
[TR]
[TD]Cottage Cheese Fruit Plate[/TD]
[TD]American Chop Suey[/TD]
[/TR]
[TR]
[TD]Cream of Wheat[/TD]
[TD]Regular [/TD]
[/TR]
[TR]
[TD]Diced Beets[/TD]
[TD]3-4gm Na (NAS)[/TD]
[/TR]
[TR]
[TD]Egg Salad Sandwich[/TD]
[TD]2gm Na[/TD]
[/TR]
[TR]
[TD]Eggplant Roulette w/ Cheese[/TD]
[TD]Low Fat/Low Chol[/TD]
[/TR]
[TR]
[TD]French Dip Sandwich[/TD]
[TD]Fiber Restricted[/TD]
[/TR]
[TR]
[TD]French Fries[/TD]
[TD]Consistent Carb[/TD]
[/TR]
[TR]
[TD]French Toast Slice w/ Syrup[/TD]
[TD]Cardiac Diabetic[/TD]
[/TR]
[TR]
[TD]Fresh Whole Banana[/TD]
[TD]2 gm K[/TD]
[/TR]
[TR]
[TD]Fruit Topping[/TD]
[TD]Lactose Restricted[/TD]
[/TR]
[TR]
[TD]Garden Salad - Italian Dressing[/TD]
[TD]Vegetarian LactoOvo[/TD]
[/TR]
[TR]
[TD]Ginger Cookies[/TD]
[TD]Gluten Restricted[/TD]
[/TR]
[TR]
[TD]Gravy[/TD]
[TD]Renal CSC[/TD]
[/TR]
[TR]
[TD]Green Beans[/TD]
[TD]Small Portion[/TD]
[/TR]
[TR]
[TD]Grilled Cheese Sandwich[/TD]
[TD]Large Portion[/TD]
[/TR]
[TR]
[TD]Ham Salad Sandwich[/TD]
[TD]Apple Pie[/TD]
[/TR]
</tbody>[/TABLE]
I hope this makes sense and sorry for the bad table, my Excel to Forum add on is on my other laptop.
Thank you
Col. (A) I have Item data that are names: Col. (B) I have data but would like b1=a1, b16=a2, b31=a3
So with column (B) +15 rows to = (A) +1
[TABLE="width: 513"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]2% Milk[/TD]
[TD]2% Milk[/TD]
[/TR]
[TR]
[TD]Ambrosia[/TD]
[TD]Regular [/TD]
[/TR]
[TR]
[TD]American Chop Suey[/TD]
[TD]3-4gm Na (NAS)[/TD]
[/TR]
[TR]
[TD]Apple Pie[/TD]
[TD]2gm Na[/TD]
[/TR]
[TR]
[TD]Bacon Strip[/TD]
[TD]Low Fat/Low Chol[/TD]
[/TR]
[TR]
[TD]Baked Beans[/TD]
[TD]Fiber Restricted[/TD]
[/TR]
[TR]
[TD]Baked Chicken Breast[/TD]
[TD]Consistent Carb[/TD]
[/TR]
[TR]
[TD]Baked Ham Pineapple Sauce[/TD]
[TD]Cardiac Diabetic[/TD]
[/TR]
[TR]
[TD]BBQ Pork on Bun[/TD]
[TD]2 gm K[/TD]
[/TR]
[TR]
[TD]Beef Barley & Veg Soup[/TD]
[TD]Lactose Restricted[/TD]
[/TR]
[TR]
[TD]Beef Lasagna[/TD]
[TD]Vegetarian LactoOvo[/TD]
[/TR]
[TR]
[TD]Beef Liver & Onions[/TD]
[TD]Gluten Restricted[/TD]
[/TR]
[TR]
[TD]Braised Cabbage[/TD]
[TD]Renal CSC[/TD]
[/TR]
[TR]
[TD]Bread Pudding[/TD]
[TD]Small Portion[/TD]
[/TR]
[TR]
[TD]Broccoli[/TD]
[TD]Large Portion[/TD]
[/TR]
[TR]
[TD]Broccoli & Cheese Quiche[/TD]
[TD]Ambrosia[/TD]
[/TR]
[TR]
[TD]Brown Bread[/TD]
[TD]Regular [/TD]
[/TR]
[TR]
[TD]Brownie[/TD]
[TD]3-4gm Na (NAS)[/TD]
[/TR]
[TR]
[TD]Brussels Sprouts[/TD]
[TD]2gm Na[/TD]
[/TR]
[TR]
[TD]Carnival Cake[/TD]
[TD]Low Fat/Low Chol[/TD]
[/TR]
[TR]
[TD]Carrot Bisque[/TD]
[TD]Fiber Restricted[/TD]
[/TR]
[TR]
[TD]Carrot Raisin Salad[/TD]
[TD]Consistent Carb[/TD]
[/TR]
[TR]
[TD]Cheese Omelet[/TD]
[TD]Cardiac Diabetic[/TD]
[/TR]
[TR]
[TD]Chicken Patty[/TD]
[TD]2 gm K[/TD]
[/TR]
[TR]
[TD]Chicken Rice Soup[/TD]
[TD]Lactose Restricted[/TD]
[/TR]
[TR]
[TD]Chicken Tenders[/TD]
[TD]Vegetarian LactoOvo[/TD]
[/TR]
[TR]
[TD]Chilled Pineapple[/TD]
[TD]Gluten Restricted[/TD]
[/TR]
[TR]
[TD]Cole Slaw[/TD]
[TD]Renal CSC[/TD]
[/TR]
[TR]
[TD]Coleslaw[/TD]
[TD]Small Portion[/TD]
[/TR]
[TR]
[TD]Cornbread[/TD]
[TD]Large Portion[/TD]
[/TR]
[TR]
[TD]Cottage Cheese Fruit Plate[/TD]
[TD]American Chop Suey[/TD]
[/TR]
[TR]
[TD]Cream of Wheat[/TD]
[TD]Regular [/TD]
[/TR]
[TR]
[TD]Diced Beets[/TD]
[TD]3-4gm Na (NAS)[/TD]
[/TR]
[TR]
[TD]Egg Salad Sandwich[/TD]
[TD]2gm Na[/TD]
[/TR]
[TR]
[TD]Eggplant Roulette w/ Cheese[/TD]
[TD]Low Fat/Low Chol[/TD]
[/TR]
[TR]
[TD]French Dip Sandwich[/TD]
[TD]Fiber Restricted[/TD]
[/TR]
[TR]
[TD]French Fries[/TD]
[TD]Consistent Carb[/TD]
[/TR]
[TR]
[TD]French Toast Slice w/ Syrup[/TD]
[TD]Cardiac Diabetic[/TD]
[/TR]
[TR]
[TD]Fresh Whole Banana[/TD]
[TD]2 gm K[/TD]
[/TR]
[TR]
[TD]Fruit Topping[/TD]
[TD]Lactose Restricted[/TD]
[/TR]
[TR]
[TD]Garden Salad - Italian Dressing[/TD]
[TD]Vegetarian LactoOvo[/TD]
[/TR]
[TR]
[TD]Ginger Cookies[/TD]
[TD]Gluten Restricted[/TD]
[/TR]
[TR]
[TD]Gravy[/TD]
[TD]Renal CSC[/TD]
[/TR]
[TR]
[TD]Green Beans[/TD]
[TD]Small Portion[/TD]
[/TR]
[TR]
[TD]Grilled Cheese Sandwich[/TD]
[TD]Large Portion[/TD]
[/TR]
[TR]
[TD]Ham Salad Sandwich[/TD]
[TD]Apple Pie[/TD]
[/TR]
</tbody>[/TABLE]
I hope this makes sense and sorry for the bad table, my Excel to Forum add on is on my other laptop.
Thank you