combination

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...

I am very new to Excel-VBA. The requirement is simple but I dont know any complex formulae or VBA, Two columns (E and F), from two worksheets, need to be taken as a single composite column and compared with each other (the composite key is always unique). This is the first sheet with the old...

Hello, Can somebody help me with this formula I have a excel With a number of columns <tbody> Country Id Title CreationDate </tbody> <colgroup><col><col><col><col></colgroup><tbody> AU 26 F 22/02/2018 DE 190 Et 22/02/2017 DE 242 E 21/02/2018 AU 277 C...

=IF((OR('Wk 1'!$E6="Mortgage",'Wk 1'!$E6="re-mortgage",'Wk 1'!$E6="re-mortgage PED")),IF((OR('Wk 1'!$F6="EA",'Wk 1'!$F6="Lettings")),"",'Wk 1'!$C6)," ") I am trying to get the cell to display the contents of C6 or return blank IF a combination of E6 equal to 'Mortgage' 're-mortgage'...

Using Excel 2000 Hi, I want VBA the could create all possible combinations using 5 groups which Min Sum is = 0 And Max Sum is =14 My 1st group contain 3 numbers in cells B2:B4 0, 1 & 2. And the rest 4 contain 0, 1, 2 & 3 in cells C2:F5 Below is the example sheet I don't how much...

Hello, currently I'm working on a tool which will include some macros. I got several sheets with information about articles in columns A-D. All rows should be checked whether this combination of cells Ax-Dx is already included in range xy in sheet "result" or not. If not, the row should be...

Hello, currently I'm working on a tool which will include some macros. I got several sheets with information about articles in columns A-D. All rows should be checked whether this combination of cells Ax-Dx is already included in range xy in sheet "result" or not. If not, the row should be...

Hi Sir I want to know the combination to meet total of sum of 4,29,042.50 from below mentioned entries: <colgroup><col></colgroup><tbody> 78,000.00 1,57,000.00 73,750.00 60,500.00 1,55,000.00 81,000.00 1,35,000.00 2,04,500.00 3,08,250.00 </tbody> Thanks Hansraj

Hi Guys, I’m a newby at excel VBA programming and struggling with handling dates. In my sheet cell B2 has a date which is, for example, 1/1/2018 but it shows as jan/18 because of formatting reasons. I have 2 variables: MyYear which has the year and MyMonth which has the month (first 3...

I need a query to compare combination of concatenated string so that "A, B, C" compared to B, A, C will return True, whilst "A, B, C" compared to "B, A, A" will return false. Effectively if I compare 2 string records, it will look at the combination (comma delimited) and will return true if the...

I am attempting to teach myself how to do userforms I can draw them and get the code behind them but I am struggling to pull everything together . If I describe what I need could someone please help out I have 7 tick boxes on a USER FROM lined up named CEA,HAV,ENT,MENIGO,PHM,PCP,RNASEp and one...

Dear Team, I need one favour from you i want to find out the combination of numbers that equals to target value. by using excel formula i tried but cant find the solution.please help me out ITS BIT URGENT. <colgroup><col style="width:48pt" width="64"> <col...

Hi Folks, i need your help to solve my requirement. I want to fill the blank cells between two cells having specific value. For example in A column i am having letters of N and Y repeatedly. Now i want to fill the blank cells between N and Y with Y letter. Blank cells between Y and N should...

I have a list of firstnames from A1 to A5 and a list of last names from B2 to B5. I need to create a nested loop that will output the different combinations of first names and last names on any of the cells within the sheet. Could someone help? Here is the list of the first names on the left...

I have one worksheet name measurementIdentity where I want to count preexisting combination (column D,H,I and J) for each Cell (unique value of column C) and band (Column K). from audit list result you will know which condition is preexisting and which is extra and which is missing. I have more...

Hi, I'm trying to work out how to get a symbol to pop up in a cell when two other cells contain a certain value. For example: If A1 and B1 contain x and y combination, C1 has a rule attached that inserts a particular symbol or text (doesn't matter what) for that particular combination. I'm...

Hi All I need to find a way to list all possible combinations/permutations on excel. I have a list of 8 games of soccer each with a possible outcome of win, draw or win. I need to be able to show every combination for the 8 different results (not including 2 results from the same game). 8...

This is an example of a formula I would like to house in the AC4 cell that will display the date above the left-most cell that contains: Any number from 0-999 Any number/”C” combination such as: 0-9C 10-99C 100-999C I would like the formula to exclude the “CO” code and any other character...

[/IMG] This is an example of a formula I would like to house in the AD4 cell that will count only the cells that contain the following number/”C” combination such as: 0-9C 10-99C 100-999C I would like the formula to exclude the “CO” code along with values that do not have a "C" on the end.