# common values

1. ### Finding Most Common String, then 2nd Most Common String, etc, in a Column

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: FVHA FVHA FVFA FVMV FVBU FVHA FVHA FVFA FVBU and many more. Here is an example of the formula for finding the most common...
2. ### FInd most common variation of product combination of with order type and complete order details

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...
3. ### Macro to copy concatenated info from one workbook, de-concatenating, and pasting into another workbook

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...
4. ### Urgent Help: Find if any of the two values is included in a range of cell

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): Column A 1. Andy 2. Susan 3. Greg 4. George 5. Peter 6. Craig If the above group (range A1:A6) includes...
5. ### VBA to plot several line chart series on a common date X axis

Hi guys.... 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...
6. ### Match text and numbers from two spreadsheets based on common value

Hi, 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...
7. ### Combine text cells using common id numbers

Hi, 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...
8. ### Capturing common values from 3 columns & moving it to next sheet

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

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back