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