Here is my problem,
I am trying to calculate the most common string, the 2nd most common string, up to the 10th most common. Here is some of the data:
and many more. Here is an example of the formula for finding the most common...
I am trying to use a sample size worth of orders to create a relationship in regards to parent-child relationships and most common occurrences of each relationship. I have tried to use several different variations of if statements along with MODE.MULT, VLOOK, TRANSPOSE, SUMPRODUCT to determine...
Hi, I need a macro button that I can click to add information from a cell in a different Workbook, based on 2 common numbers (called D No.and Z No. ). The info in the cell that I want to copy has been concatenated. The concatenated info is in the form of 5 digit numbers each separated by a...
I want to know the formula to find if any of the two values is included in a range of cell.
Example, below is a group of names (similarly I have various other groups with different names):
If the above group (range A1:A6) includes...
I have a Workbook (Excel 2010) with several Worksheets - each Worksheet represents a business loan, and each loan has a different start and predicted end date.
On each worksheet I have a column with the Next Payment Date, and another column with the Balance after the payment has...
I have one spreadsheet with two columns, with the headers: ID number and Chemical name. I have another spreadsheet with six columns: ID number, Chemical name, TEP 1, TEP 2, TEP 3 and TEP 4 (TEPs are numeric risk scores). I need to know what the TEP values are for the chemicals in the first...
I have 15 spreadsheets, each having a column of id numbers for chemicals and a column of corresponding chemical names. Each file is a list of chemicals that cause one condition. Each file is a list of chemicals that are either recognized or suspected of causing a certain health condition...
I have got to a point where my mind is at death point. Frankly, I am not an Excel Guru but yes, do have more than general knowledge of Excel.
I had a spreadsheet with 3 columns (A.B & C) & 40,000 lines in them.
Objective is to work on a formula/code to go complete following steps...