common values

  1. N

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

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

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

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

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

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

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

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

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top