combination

Hello Everyone, I have been working on a spreadsheet created by someone else, however I cannot figure below formula. Can anyone help explain it? Thank you. =XIRR(INDIRECT("R"&MATCH(B4,A:A,0)&":R"&MATCH(K4,A:A,0)),INDIRECT("A"&MATCH(B4,A:A,0)&":A"&MATCH(K4,A:A,0)))

Hi all, Hope You can help me. I have a pretty big table and want some information out of it but don't know how to do it. Hope You guys (and girls) have some ideas. The idea of the table is: <tbody> A B C D E F G H I J Name 1 V V V V V V V V V V Name 2 V V Name 3 V V V V...

Hello, Looking for a formula to generate all possible UNIQUE combination of the contents of 3 rows. I want to avoid results with the same content in different positions (such as aac, caa, aca should be appear only once, regardless of which) Row1 Row2 Row3 a a a b b...

is there a way to embed an "and statement" inside a sumif statement so that it sumifs based on the combination of 2 criteria? or is there a better way to do it?

Hello, My file has company codes(CoCd) in col's and Profit centers(PC) in rows, with $'s assigned to them. I need to retrieve $'s specific to a PC and CoCd combination. Issue is sometimes same CoCds are in multiple columns. So can't do a simple sumif or Hlookup. E.g. B30 PC0001 B31 PC0002 B32...

Hi everyone, I'm hoping you could help me here.. I have a string from where I want to return the characters between the first " " (space) and the second: e.g. 3_ECOB B15 5 PATAKS-PE/CLEAR - I'm trying to get B15. I'm using a combination of left and instr but I'm not able to get to the...

I have 2 columns each will unique data. 1st column has 25 data entries. 2nd column has 13 data entries. How do I combine the data so that in the 3rd column will have all 38 data entries. The data must be sorted alphabetically automatically, so using formulas. - I need the formula for the...

Hi Everyone, Forgive me in advance for posting for what will be for many of you a basic question, so I thank you in advance for your help and understanding. I have a spreadsheet, that has 4 columns of numbers and I want to return every combination of the those numbers available in a new...

Please help me to find a solution...I have populated column C and Column D with single numbers and Column E the numbers are concatenated. How do I generate a list of all possible COMBINATIONS of the Column E with all the other single numbers located in Columns C and D except numbers located in...

Hi, Is it possible to give a numerical value based on the contents of another cell? In cell A1 would be any combination of the letters representing the days of the week; MTUWTHFSA For example, M would equal 2, TU would equal 3, W would equal 5, TH would equal 10, F would equal 20, and SA...

Hi! I'm new to VBA, and I've had a lot of help reading this forum and the extreme knowledge within, thank you all for that. Now a question that I haven't found the answer to: I have a column each for id, name, mother and father. I need a new column with an unique id that connects the...

Hi everyone, I currently write my Master thesis in the field of renewable energy. I want to implement the famous mean-variance analysis by Markowitz to show how all possible combinations of 10 wind parks are different in terms of return/risk ratio. There must be 2 specific formulas...

Hi everyone, I've come this far: Test.xlsx But I can't explode the subparts. Tricky part is SubPart2 also includes SubPart3. Well, it's 4 am here and I am like :banghead::banghead::banghead: I've tried every single relationship combination. Every Column and row combination but no way...

combinations of numbers that sum to a given total excel I've got a column of numbers, and I'd like to find the best combination of three of these numbers. In our case, the best combination is a sum that is as close as possible to our goal number For example, we have a goal of 100 and this column...

So since all pick 3 and pick 4 numbers have different combinations possible, I want excel to highlight them based on how many times each combination repeats. I want to do this for 3 and 4 digit sets separately. Ultimately I want to paste all winning numbers in column A in let's say every March...

Hi, I have in cell B4, 201814, formatted as number. I am using the following combination of Left & Right to change the number to 201714. =LEFT(B4,4)-1&RIGHT(B4,2) This gives me the desired result. I am then using this within a Match or Vlookup formula (both of which return N/A, when the data...

I want to make Marubozu Candles in a cell (D3) Input cells: A3: Either 1 or 2 B3: Either 3 or 4 D3 Candle should be EITHER of 4 types: If A3:B3 combination is 1,3 then FULL GREEN CANDLE If A3:B3 combination is 2,3 then FULL RED CANDLE If A3:B3 combination is 1,4 then HALF GREEN CANDLE (HALF...

I have this question: Create a Sub with any combination of nested loops. This nested loop should take the baby girl names input (below) and print out every possible combination. These input names will need to appear in your workbook somewhere. Print out the combinations in the workbook itself...

Hi everyone, I have a tricky task :) Let me clarify that step by step below. Input table with 5 columns columns are: combination, place1, place2, place3, income column combination represents a number of each combination (combination of 3 places) place1, 2, 3 are basically points where a car...

Book1ABCDEFGHIJKLM1IDTechnologyPowerEnergyIDSegment 1Segment 2Segment 3Segment 4Segment...