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

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