Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-10-2018, 02:35 AM
wasmabo wasmabo is offline Creating a shopping list, where dublicates are automatically added Windows XP Creating a shopping list, where dublicates are automatically added Office 2016
Novice
Creating a shopping list, where dublicates are automatically added
 
Join Date: Jan 2018
Posts: 4
wasmabo is on a distinguished road
Default Creating a shopping list, where dublicates are automatically added

I am in charge of planning the menu for a camp full of kids, for 8 days. It's a lot of recipes, and a lot of food!



I have made a spread sheet with the men and all the ingredients needed for the recipes for all of the days etc., but I want to make an easy shopping list.

It's easy to copy all the listed ingredients and their amounts into one long list, but adding together dublicates is very difficult. Is there a way I can make excel read the item name, and automatically add together the quantaty? Otherwise things like salt, pepper, onion, milk are going to be on the list a thousand times, and I'll lose my overview of how much is bought.

I have made a very simplified excel sheet of the situation, attached.

It is very important that the sheet stays as interactive as possible, as the number of kids, and their various intolorances etc. keeps changing, plus we may want to change some ingredients and quantaties pr kid.

I feel like there should be an easy solution, I'm just not quite sure what to search for!
Hope someone out there can help

(hope it is uploaded in the correct format)
Attached Files
File Type: xlsx example of shopping list.xlsx (11.3 KB, 1 views)
Reply With Quote
  #2  
Old 01-10-2018, 04:03 AM
deciog deciog is offline Creating a shopping list, where dublicates are automatically added Windows 10 Creating a shopping list, where dublicates are automatically added Office 2016
Novice
 
Join Date: Feb 2017
Posts: 6
deciog is on a distinguished road
Default

See if it's this way

Decio
Attached Files
File Type: xlsx example of shopping list Decio.xlsx (11.5 KB, 2 views)
Reply With Quote
  #3  
Old 01-10-2018, 04:11 AM
wasmabo wasmabo is offline Creating a shopping list, where dublicates are automatically added Windows XP Creating a shopping list, where dublicates are automatically added Office 2016
Novice
Creating a shopping list, where dublicates are automatically added
 
Join Date: Jan 2018
Posts: 4
wasmabo is on a distinguished road
Default

Quote:
Originally Posted by deciog View Post
See if it's this way

Decio
That looks great! So, if I am reading it right, it is saying to add together anything from H and M column, if the label in the J or O column matches what I have already labled in the shopping list (column C). So this is deffinitely the perfect way to get it to add the list up!

However, can this also work before I have any info in the C column? So the formula know that it should EITHER put the item as a new item in column C, OR add it's value to an already existing post?
Reply With Quote
  #4  
Old 01-10-2018, 04:16 AM
deciog deciog is offline Creating a shopping list, where dublicates are automatically added Windows 10 Creating a shopping list, where dublicates are automatically added Office 2016
Novice
 
Join Date: Feb 2017
Posts: 6
deciog is on a distinguished road
Default

That's right, do tests.

Decio
Reply With Quote
  #5  
Old 01-10-2018, 04:18 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Creating a shopping list, where dublicates are automatically added Windows 7 64bit Creating a shopping list, where dublicates are automatically added Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,416
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

@wasmabo
Hi and welcome to the board

Please do not quote entire posts unnecessarily. They clutter the thread and make it hard to read.
Thank you
Reply With Quote
  #6  
Old 01-10-2018, 04:48 AM
wasmabo wasmabo is offline Creating a shopping list, where dublicates are automatically added Windows XP Creating a shopping list, where dublicates are automatically added Office 2016
Novice
Creating a shopping list, where dublicates are automatically added
 
Join Date: Jan 2018
Posts: 4
wasmabo is on a distinguished road
Default

@decio

I am struggleing when I try to implement it in my actual document.
When I test it in the test document it works fine, and I can even add an extra day. But once I try to put it in the 'real' document, it adds up to zero, even though I have double checked that the spelling is the same. Is there some formatting or etc. I have to be aware of?

Attached is the actual document, as well as the 3 day version of the example. The reason I use an example post, is that real document is not in english, and contains notes etc, so sorry if it is very confusing to look at!

@pecoflyer
Sorry, will keep it in mind!
Attached Files
File Type: xlsx oao 1.xlsx (16.2 KB, 1 views)
File Type: xlsx example of shopping list Decio 3 days.xlsx (11.9 KB, 3 views)
Reply With Quote
  #7  
Old 01-10-2018, 05:10 AM
deciog deciog is offline Creating a shopping list, where dublicates are automatically added Windows 10 Creating a shopping list, where dublicates are automatically added Office 2016
Novice
 
Join Date: Feb 2017
Posts: 6
deciog is on a distinguished road
Default

Note that this is different from the original, so the formula changes, confers

I'm using Google Translator because I do not speak or write English

Decio
Attached Files
File Type: xlsx oao 1 Decio.xlsx (16.1 KB, 9 views)
Reply With Quote
  #8  
Old 01-10-2018, 05:48 AM
wasmabo wasmabo is offline Creating a shopping list, where dublicates are automatically added Windows XP Creating a shopping list, where dublicates are automatically added Office 2016
Novice
Creating a shopping list, where dublicates are automatically added
 
Join Date: Jan 2018
Posts: 4
wasmabo is on a distinguished road
Default

That's so great, Thank you so much decio!

I will deffinitely give this formula to other people as well, has made everything much easier, thank you
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Shopping list from recipes - help! silawtz Excel 20 09-18-2016 09:02 PM
Random contacts being automatically added to contact list jjmclell Outlook 0 03-10-2015 07:36 AM
Creating a shopping list, where dublicates are automatically added Creating a merged list with added numbers Dbruhns Excel 7 07-25-2014 04:48 PM
Creating a shopping list, where dublicates are automatically added "Grow a document' with text automatically added to new page bpercival Word 1 02-07-2012 03:33 PM
Form field to automatically be added to header? razberri Word VBA 3 02-22-2010 03:48 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft