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

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top