Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 07-06-2017, 04:28 PM
Kubi Kubi is offline Windows XP Office XP
Advanced Beginner
 
Join Date: May 2017
Posts: 32
Kubi is on a distinguished road
Default Expand on carton count

can you help me expand on this further by adding a pallet count to this i.e. 30 full boxes = 1 pallet

Thanks.

=INT(A2/B2)&" full box of "&B2&" and "&MOD(A2,B2)&" inner's"



Edit Mod

This post is related to http://www.msofficeforums.com/excel/...pack-qtys.html

Last edited by Pecoflyer; 07-07-2017 at 08:42 AM. Reason: Cut thread
Reply With Quote
  #2  
Old 07-06-2017, 11:19 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 788
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

Is it like the attached that you want?
Attached Files
File Type: xlsx Boxes_2.xlsx (11.0 KB, 5 views)
Reply With Quote
  #3  
Old 07-06-2017, 11:40 PM
Kubi Kubi is offline Windows XP Office XP
Advanced Beginner
 
Join Date: May 2017
Posts: 32
Kubi is on a distinguished road
Default apply it to this current sheet?

Sorry could you show me how to apply it to this current set-up
Attached Files
File Type: xlsx Test.xlsx (10.4 KB, 8 views)
Reply With Quote
  #4  
Old 07-07-2017, 12:16 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 788
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

Please give so many examples (including expected results and form of result) so that I have a real chance to test.
I assumed pallet size always would be 30 as you didn't mention otherwise.
Reply With Quote
  #5  
Old 07-07-2017, 12:31 AM
Kubi Kubi is offline Windows XP Office XP
Advanced Beginner
 
Join Date: May 2017
Posts: 32
Kubi is on a distinguished road
Default

G2 and H2 use VLOOKUP to return the specific pack sizes of the product. the current formula being used is....

=INT(H2/I2)&" full box of "&I2&" and "&MOD(H2,I2)&" inner's "

I just want to add pallets to this, the pallet qty will be determined by the VLOOKUP as is the pack Qty.
Reply With Quote
  #6  
Old 07-07-2017, 04:49 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 788
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

Maybe like shown in column K if you can accept a helper column (column N)
Attached Files
File Type: xlsx RC Out_2.xlsx (41.6 KB, 3 views)
Reply With Quote
  #7  
Old 07-07-2017, 08:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,914
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

@kubi

Hi
if you have a new question, even pertaining to an existing thread, it's always best to start a new thread eventually adding a link.
This will give you a better chance of getting an answer

I did it for you this time
Reply With Quote
  #8  
Old 07-07-2017, 01:15 PM
Kubi Kubi is offline Windows XP Office XP
Advanced Beginner
 
Join Date: May 2017
Posts: 32
Kubi is on a distinguished road
Default Almost there

I am having trouble with column M returning a carton count even if a full pallet has been picked which then makes the final count wrong.

Inners and pallet counts work fine, just carton picks needing fixing.

Any help?
Attached Files
File Type: xlsx Test#2.xlsx (11.2 KB, 4 views)
Reply With Quote
  #9  
Old 07-07-2017, 09:08 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 788
xor is a jewel in the roughxor is a jewel in the roughxor is a jewel in the rough
Default

It seems difficult for you to give illustrative examples with expected results.
Attached Files
File Type: xlsx Boxes_3.xlsx (12.2 KB, 7 views)
Reply With Quote
  #10  
Old 07-07-2017, 09:19 PM
Kubi Kubi is offline Windows XP Office XP
Advanced Beginner
 
Join Date: May 2017
Posts: 32
Kubi is on a distinguished road
Default

I thought it rather self explainitory what I was having trouble with sorry, but yes this apares to be working.

Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to expand the gridlines Shahir Arifin Word 2 11-25-2016 10:40 AM
Getting the Count formula to count all rows Jennifer Murphy Word Tables 11 08-23-2016 09:37 PM
How not disable expand/collapse LVP Word 3 12-21-2014 12:12 PM
Expand a Word table SMT Word 2 04-11-2011 04:40 AM
Grouping - expand all ejohns Excel 0 07-17-2009 07:15 AM


All times are GMT -7. The time now is 08:48 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft