sizes

Hello, So I have a group of text values for Sizes like twins, Small, Medium, Large etc. in a sheet and I'm assigning values to those sizes. I'm using the formula as below and it always gives me error. Please help. Here is the formula I'm trying to use, =LOOKUP('Prepaid Customer'!Y2,{"Twins"...

I have two data files, containing very different material, but both of length 45,737 KB. I am running on a 64bit version. Now that seems to be rather too big a coincidence. I know file sizes are not meant to be limited, but I am concerned in case there is some restriction in fact. This is...

Hello, I have 475 feet of pipe that I need to cut to the following sizes. Each pipe is 40 feet long (480 Inches) so I want to optimize the cuts in order to stay as close as possible to 12 pipes. <colgroup><col><col></colgroup><tbody> Inches QTY 8.00 20 10.00 6 12.00 8 27.00 2 32.00 6...

Good Morning I need to understand how to write macros to automatically resize worksheets to display the same on all computer screen sizes. theamateur1939

Is it possible to get rid of the row labels for the pivot tables or is there a better way to sort the sizes based on the corresponding size with machine number?

Hi All I have a 2 tab spreadsheet Tab 1 is the front facing figures sheet for sales team Tab 2 is the formulas used to work comms at the end of the month Normally I copy and paste no issue But I have mad the row sizes different so when i copy and paste now it doesn't update the cell sizes...

Could someone please confirm best formula for MINIMUM CHARGE - £ 5,000 IF A RAFFLE DOESN'T REACH £ 5,000 THEN THE AMOUNT COLLECTED ROLLS OVER I.E. RAFFLE - £ 2000 FORMULA CALCULATES THAT £ 3000 ROLLS OVER Also I have a formula tab with workings and styles i.e. cell sizes but when I copy...

Hi, I am stuck on the following problem: I have created a VBA Excel Userform that calculates the max and min hole size for a given bolt size. All calculations etc are contained within the code on the form, I have not and do not want to reference a spreadsheet. I’ve added a Combobox to...

Hi Everyone, Not sure if this is posible, but creating a new document with about 90 sheets, every sheet has a picture or two in it, many of which are the same but i'm finding the pictures are not maintining there sizes as i copy paste move design ect. I've done "Do not move or size with picture...

I am trying to figure out how to add sumif on all the different sheets if they match a certain t-shirt. I need to count all the smalls, large, x-large etc. on each sheet of the sizes and color on the master sheet. https://1drv.ms/x/s!AsTgNTf7crASzn9MB3Jgc7H8QUZC Any help would be GREATLY...

Hi I have data that I input in to a chart but the output is MBs and id prefer TB due to the large sizes of data. Could anyone help with a formula? Thanks!

I am trying to figure out some way to take a string and make sure its a certain number of characters (I would say width but that would be much more involved given characters and point sizes are so confusing!!!) and center it via spaces. For instance, if I have a string "cat" but I want it to...

Hi guys. I have a table with hundreds of thousands of article numbers connected to customer numbers. All our article numbers comes in different sizes, but many customers have some sizes registered, but are missing some. I have 2 tables: 1. With all the article numbers with the customer...

When I change to any sheet I would like the entire workbook to recalculate. I have a table that has sizes on it and then that table populates about 100 forms but when I change sheets i have to press F9 to get the sheet to calculate to show the sizes... I have Automatic calculate on plus I have...

Hi guys, Made an account here because i have been trying to figuring this out for hours now to no prevail. Maybe you guys can find a solution. I have a table with several thousand article numbers, and i want to create a new table where all the sizes for the same article number are gathered up...

What formula do I use to have Excel look at 4 columns (D,E,F,G), the first three (D,E,F) are material size, the fourth (G) is the total of the parts for the material size. I figured it'd be SUMIF, but I can't figure out how to link the first three cells without using TEXTJOIN and creating a...

Hi all, I work at a glazier and I am trying to create a grid for the office girls to work from to be able to quote people over the phone easily. We cut glass from standard sheet sizes that we stock so there is a size range to work from and here is an example: <colgroup><col width="206"><col...

Hi guys, I need to find the smallest batch size of a product that is made on particular equipment So on the right I have Equipment 1 (Cell K4) and on this equipment, Product A and Product are made What are the smallest batch sizes of these products? The source table is on the left The results...

hi i have got multiple sizes of stock and i want to separate them in a different groups for example Group 1 (G1) will be less the 10-8-8 640 Group 2 (G2) bigger then G1 and less then 20-10-10 2000 Group 3 (G3) bigger then G2 and less then 40-30-10 12000 i want a formula that will compare...

Hi, I have some formulas in which I would like to filter my data, as the normal "filter" function don't remove data in the ranges, the formulas won't change. So for example, in A3:A2000 I have quantity and in B3:B2000 I have sizes: S, L and XL Let's say I have a formula to sum the quantity...