im looking to piece together all possible part number combinations with a one condition:
The values in Column A must come before the values in Column B. The values in Column B must come before the values in Column C. And So forth...
Example: If Column A had the values of A, B, C; Column B had the values of -1, -2, -3; and Column C had the values of -01, -02, -03
The outcome(s) would be: A-1-01, A-1-02, A-1-03 and so forth...
How can I get it to do that? But I need the flexibility of adding on more "options" should the part number be bigger (for future part number combinations).
I have attached an example. If I have a set of numbers such as the one attached, is it possible to create a formula that will show me all the combinations of numbers that add up to 55.52? In the attached I have highlighted in different colours all the number combinations that add up to 55.52. The numbers highlighted in blue appear within more then one combination. Is there a formula that can do this for me, instead of randomly adding numbers hoping they add up to 55.52.
I have attached an example. If I have a set of numbers such as the one attached, is it possible to create a formula that will show me all the combinations of numbers that add up to 55.52? In the attached I have highlighted in different colours all the number combinations that add up to 55.52. The numbers highlighted in blue appear within more then one combination. Is there a formula that can do this for me, instead of randomly adding numbers hoping they add up to 55.52.
I have a spreadsheet with 2 worksheets. On the first "active parts" I have a list of active part numbers and on the second "All Parts" I have all of the parts available.
I want to compare every part in the All Parts worksheet to see if the part number exists on the Active Parts sheet - if it's there, I would like it to return the value "Active" in column B in All Parts. I have a formula in column B in All Parts that seems to work for the first few, but as soon as it finds one that is active, the rest of the cells below all return "Active".
I want to have a sheet with all the previous drawings for the florida lottery. Then I want excel to ask me how many numbers do I wish to play.
Then when I say 12 (for example) it would pick 12 numbers from 1 to 53 and match all possible comibinations of thoses numbers to the the previous drawings and tell me wich 12 number combination would have won more times then others. So it would need to compare each possible 12 nmber combination to each other and see wich one won more 6outof6, 5outof5, 4outof4, and 3outof3. Then give me the one with the highest winings
Now there is the number and the number(A) that it value it represents (B). This is what I want. I want to see all possible number combinations between the upper and lower A columns listed veritcally under the whole set, with out duplicating any numbers and with the upper numbers only being in the 1st position and the lower numbers being in the second position Ex( 4-1, 4-8, 4-2, 7-4, 7-1, ect, ect (listed vertically). Now in column B under, right beside each possible combination I want to see the result of the two values multiplied (ex. beside 4-1 I would like to see 0.1)
So below that mess listed above I want to see something like this
A B 4-1 0.1 4-8 0.0125 ect ect ect
I want to be able to swith the values around and have it automatically make the correction.
I wish to calculate the total number of combinations using the number of entries in 6 fields regardless of what the actual entries are. In other words only the number of entries are relevant. They look as follows for example:
Field A1=4; Field B1=3,5,12; Field C1=9,2,11; Field D1=14,1,5; Field E1=18,2; Field F1=3,7
Calculating it using a calculator is too tedious since I have several rows of data with similar entries. I just need to know what the total number of combinations are eg in the above example 1X3x3X3X2X2=108 using some excel formula.
After looking at other similar post titles I could not find a formula to work exactly proper.
I have attatched a sample of my problem. What I need is for cells E4:J4 to look for a match in cells B4:B16 and give a value of " Yes or No " in cell K4 if a match is found. Then copy down formula through E5:J5 to B4:B16 - E9:J9 to B4:B16. As my examples indicate Cells K4 would = yes, K5 = yes, K6 = yes, K7 = no, K8 = no, K9 = yes. Column D is the results, Columns E-J represents all combinations of column D.
I have tried the following formulas but they did not work entirely correct.
Say I enter the following values into a spreadsheet: 5 7 4 24 32
Is there a way to enter the value "36" and have Excel find the two values of 32 and 4 which add up to 36 for me? I will obviously be dealing with much larger spreadsheets and would like to somehow save time by not having to hunt down possible combinations of the total value I'm searching for.
as an example i will use the national lottery. numbers 1 to 49 inclusive. i need a formula that will list all the possibile 6 number combinations not repeating any.
I have a spreadsheet listing all my vehicles and their respective oil filter part number. Now, some vehicles share the same oil filter and I am trying to find a way to return the vehicle description when using the filter # as a value. In my example below, I am looking to fill the third column with the Vehicle that also shares the same oil filter number. i.e. in the Dodge row, toyota would appear in the third column and vice versa in the Toyota row.
Vehicle Oil Filter # Also used with Dodge 51515 Honda 54565 Toyota 51515
I am not well versed in excel lingo which is probably why I have a hard time coming up with a method that works.
I am trying to find a way to calculate the number of hours between date/times found in separate rows. The attached data set will help to envision what I am talking about.
For each couple of rows, I need to find a way to calculate the number of hours elapsed from row 1 to row 2. In the first example, to calculate the number of hours between 12/2/2009 8:56:51 and 12/4/2009 6:35:27.
A1:A10 contains text (say colors) and B1:B10 also text (say vegetables). I need a formula to count the number of times a certain combination of numbers and vegetables appear in the same column, so if "red" and "carrot" appeared in A4 and B4 and also in A6 and B6, the result would be 2.
How can I drop the whole number part of a number and leaving only the decimal part of the number. Then multiply the decimal part of the number with a number. Then repeat this in a sequence. The object is to convert Lat and Long decimals to Hr. Min. Sec.
When inserting "1" in the cell under soup, i was thinking it will bring up a list of its ingredients and how much of that ingredient. The values are listed in the same spread sheet below.
The amount of the ingredient is in D50 (80grams) and the item type next to it in E50(onion)
Is it possible to put in "1" soup then it displays all the items in both those cells range example(D50-E50 to D60-E60)? Is it possible to put the value "2" in soup and it shows double the measurements? example (160grams) (onion)
I am trying to do a VLOOKUP on a worksheet with a list of our Part numbers. The Part numbers begin with zero and go into the alphabet with anywhere from 3 digits upto 18.
When I sort the sheet Excel sorts the numeric by the number of digits in the number AND totally ignores the first zero. I can not format as numbers since again Excel drops the first zero. Therefore, when I do the VLOOKUP it will not look through the entire numeric list for the higher digit numbers. Is there anyway to resolve my VLOOKUP issue with indexing or?
I'll try to keep this brief. Our part #'s look like this. XP014567. Where the first pair of characters stand for a value(say XP=Bolt), the second pair stand for a value(01= Grade 2), and so on. What I would like to be able to do is type in the part numer and have the description automatically populate. Is there an easy way to do this? I'm running Excel 2003.
I have part numbers in a column that look like the numbers listed below. All numbers begin with A, so the default sort begins with the first number. I would like to sort the list using the middle three numbers denoted by the red x's in the first example. Is this possible?
A 385 XXX 0055 A 385 466 0060 A 385 466 0160 A 385 584 7024 A 387 284 0185 A 388 017 0160 A 389 260 1485 A 389 262 0293 A 389 262 4935 A 389 262 9134 A 389 267 2819 A 389 267 3319 A 393 328 0065 A 398 267 3319 A 403 990 0210 A 403 997 0620 A 404 260 0074
I was given this new task this year. Normally this process is done by hand, by one of the managers, but since it now belongs to me, I look at it as being a little to tedious to do. So I would rather have excel do it for me.
We have about 5 CSRs who handle clients based on the first letter in the clients name. I guess to make this easier to update in the future if the macro would respond to a cell reference for the number of CSRs that would be great. I will need to perform this task Annually, and of course each time a CSR leaves or we hire another one. This way work loads are kept close to the same.
I have a list of letters in column A. Each of these letters has a corresponding number of clients in column B. I have been given the task to try to split these values equally between the 5 individuals. I know that since the numbers don’t all add up and divide equally it can’t be done easily by hand.
I have attached an excel file with what I have in the sheet. Sheet 2 shows what I would like to have as an example as output on the same sheet. (What I put on the sheet is an example of the way I want it to look, are not close to adding up to a "close to equal" total.)
I want excel formula to calculate the sum the value of partused depends upon serialno repeats where repeats of end of serial no i want result at end of every multiple serial no end cell.
I have a USB scanner connected to a PC. Data is entered into Excel when the part number barcode on a box is scanned. I have two worksheets that I will be scanning part numbers into, one is Group A and the other is Group B. On Group A's sheet there is a list of Group B part numbers that will be used for the lookup procedure when the barcode is scanned. The same is true for Group B's sheet. The groups should never be mixed, so if part number "B005" is scanned into Group A's sheet it should cause an error message to pop up. I've attached a workbook as an example. Is it possible to do this with VBA?
I have a list of part numbers and a new drawing number and old drawing number. I'm am trying to put this list on the second page of a workbook and write a code on thie first page that allows a person to enter the part number and the old and new drawing numbers will be displayed.
I would like to use an (I think) easy SUMIFS formula. In this case I'm using only 3 criteria, and 2 of them work perfectly. With the third I want to SUM only IF the series begins with 112 in the example.
Can you cut out part of a number and replace it in another cell. For example
A1 come in as ###+### and it will not always be a three digts all the time but I would like to keep the number in front of the "+" in A1 and the number behind the "+" into A2 cell.
