Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-19-2022, 11:25 AM
Sreejith Damodaran Sreejith Damodaran is offline Formula to find number of air filters I can use Windows 10 Formula to find number of air filters I can use Office 2013
Novice
Formula to find number of air filters I can use
 
Join Date: May 2022
Posts: 5
Sreejith Damodaran is on a distinguished road
Default Formula to find number of air filters I can use

Hello all the genius



Its always a big task for me to pull out different size of air filters from my warehouse to alter it to smaller size according to my customers requirements

If anybody advise me a formula to find out what are the sizes and how many air filters I can remove from my existing stock to meet my customers demand. I am pretty sure that this will help me to save a lot of my time instead of arranging back the excess filters after alteration.

I really appreciate your advise. Thank you
Attached Files
File Type: xlsx Airfilters - Workings.xlsx (9.6 KB, 20 views)
Reply With Quote
  #2  
Old 05-20-2022, 01:13 PM
p45cal's Avatar
p45cal p45cal is offline Formula to find number of air filters I can use Windows 10 Formula to find number of air filters I can use Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Can you make 4
20*25*1
from 1
20*25*4
?
Reply With Quote
  #3  
Old 05-20-2022, 01:27 PM
Sreejith Damodaran Sreejith Damodaran is offline Formula to find number of air filters I can use Windows 10 Formula to find number of air filters I can use Office 2013
Novice
Formula to find number of air filters I can use
 
Join Date: May 2022
Posts: 5
Sreejith Damodaran is on a distinguished road
Default

Hello P45cal ,

the qty I have is in column D.

Thanks.
Reply With Quote
  #4  
Old 05-20-2022, 01:42 PM
p45cal's Avatar
p45cal p45cal is offline Formula to find number of air filters I can use Windows 10 Formula to find number of air filters I can use Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by Sreejith Damodaran View Post
to alter it to smaller size according to my customers requirements
So again,
Can you make 4
20*25*1 (you have none, the customer wants 100)
from 1
20*25*4 (you have 108, so you might be able to make 100 from 25 of them)
?


As another example, the customer wants 115 of 20*20*1, you have no 20*20*1 at all in stock, but you do have stock:
Sl 1: 20*20*2 (300 of them)

and also

Sl2: 20*20*2 (576 of them)

so can you supply 115 of 20*20*1 from about 58 of 20*20*2
?
Reply With Quote
  #5  
Old 05-20-2022, 02:21 PM
Sreejith Damodaran Sreejith Damodaran is offline Formula to find number of air filters I can use Windows 10 Formula to find number of air filters I can use Office 2013
Novice
Formula to find number of air filters I can use
 
Join Date: May 2022
Posts: 5
Sreejith Damodaran is on a distinguished road
Default

Hi P45cal,

Once again thank you for your questions. Thing is that if I cannot make/alter filters based on my current stock, its fine. I will supply those sizes later. But at least if I get a formula to find out what size I have to use and how many I can make that will be great

Thank you.
Reply With Quote
  #6  
Old 05-20-2022, 02:37 PM
p45cal's Avatar
p45cal p45cal is offline Formula to find number of air filters I can use Windows 10 Formula to find number of air filters I can use Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by Sreejith Damodaran View Post
Hi P45cal,

Once again thank you for your questions. Thing is that if I cannot make/alter filters based on my current stock, its fine. I will supply those sizes later. But at least if I get a formula to find out what size I have to use and how many I can make that will be great

Thank you.
I can't tell you how many you can make until I know whether or not you can make 4 of 20*25*1 from 1 of 20*25*4
So I can't even begin to put together a solution.
Reply With Quote
  #7  
Old 05-20-2022, 02:48 PM
Sreejith Damodaran Sreejith Damodaran is offline Formula to find number of air filters I can use Windows 10 Formula to find number of air filters I can use Office 2013
Novice
Formula to find number of air filters I can use
 
Join Date: May 2022
Posts: 5
Sreejith Damodaran is on a distinguished road
Default

Its hard to make 4pcs of 20*25*1 from 1 of 20*25*4 Maximum I can make 2 of 20*25*1 perfectly.

Thank you.
Reply With Quote
  #8  
Old 05-21-2022, 08:54 AM
p45cal's Avatar
p45cal p45cal is offline Formula to find number of air filters I can use Windows 10 Formula to find number of air filters I can use Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

The attached is a mess but is only work in progress.
I've concentrated on 'Which are the sizes I can use from my existing stock to meet my customers demand?' because there are currently no exact matches of the requirements in stock at all.
There's a table at cell K3 of the attached which is a repeat of your table at cell F3 with an added column which is a list of stock Sl Nos where there is not zero stock and where you should be able to cut the required size from larger stock sizes. The list is in the same order as your existing stock list.
At the moment, that list lists the SL No and the stock size in the form:
SL No: nn*nn*n
If the data in either of your 2 tables change, to update the new table, right-click it and choose Refresh.

Does this look like it could be the start of a way forward for you?
Attached Files
File Type: xlsx msofficeforums49053Airfilters - Workings.xlsx (22.8 KB, 7 views)
Reply With Quote
  #9  
Old 05-21-2022, 09:58 AM
p45cal's Avatar
p45cal p45cal is offline Formula to find number of air filters I can use Windows 10 Formula to find number of air filters I can use Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Note I've updated the file attached to my previous message about an hour after I first posted because of an error.
Reply With Quote
  #10  
Old 05-23-2022, 08:53 AM
Sreejith Damodaran Sreejith Damodaran is offline Formula to find number of air filters I can use Windows 10 Formula to find number of air filters I can use Office 2013
Novice
Formula to find number of air filters I can use
 
Join Date: May 2022
Posts: 5
Sreejith Damodaran is on a distinguished road
Default

Dear P45cal,

Thank you soo soooo much for your assistance... I will work on this file and if I need any additional help definitely I will get back to you. Also I will update you with proper sizes that we are going to provide to our customers. So that you can assist me again with the qty I can pull out from my existing stock.

Thank you very much.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to find the wrong number when you want to hit 0? tomplom Excel 2 12-26-2018 05:27 AM
Formula to find number of air filters I can use VBA to find any nine-figure number Chayes Word VBA 2 05-19-2017 06:06 AM
find IP in range / find number between numbers gn28 Excel 4 06-14-2015 03:46 PM
How to find number of coma and then add that number of rows in word using macro? PRA007 Word VBA 7 05-27-2015 10:45 PM
Formula to find number of air filters I can use Need Help to Find a Number and replace Allen Word 5 11-20-2014 10:33 PM

Other Forums: Access Forums

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


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