duplicate values lookup

  1. M

    Ranking text based on duplicate text in a column

    Hello, I have a large worksheet with 8693 rows and 69 columns and I would like to rank how many times a customers name is mentioned in a column. I'm familiar with filtering and pivot tables but my skill levels require I manually add up the customer names. I thought I could use a =RANK formula...
  2. R

    Duplicated lookup value needing unique return

    I have data that can be duplicated but will need to return specific serial numbers. In one tab i will have the following: <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> Name Model Color PO ABC 123 White PO123 ABC 123 White PO123...
  3. J

    VLOOKUP w/ Duplicate Values

    Hello, and thanks in advance for your help! I have a workbook with many worksheets. Some worksheets have 25-30 columns and up to 45,000 rows of data. My dilemma follows... In column "I" on the ENTRIES worksheet, I have a VLOOKUP formula I use, but I doesn't work properly if there is more...
  4. D

    Use index to look up and return multiple unique values

    Hi, I need to be able to find multiple values where the same thing occurs. This also needs to be able to use subtotal so that if I filter it only returns the names shown. Poor English so I'll use this table to explain: I need to fins any pupils name where they have particular values. So for...
  5. J

    One item name = 10 indiv. Parts

    Hello, I'm pretty new to Excel, please help with this task. The company I work is building some fenders for a customer. Each fender has an individual part name (M4599), but it's actually an assembly of various parts with different part names. What I'm trying to accomplish is being able to...
  6. V

    Lookup with duplicate values.

    Hi Friends, I have my data arranged in a table which appears to be like this: File ID QA 3803 Vishnu 4006 Shalini 3803 Akanksha 5034 Sanchit 5034 Shalini 3803 ****iz I wants multiple results here from lookup where I need all QA names for a give File ID. When I am trying...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top