duplicate values lookup

In the first image in column F I have name of customers, and in column K I have deposited amount (here are multiple amounts which are similar). In the 2nd image, in column E I have received amount of amount and in Column H I want to input names of customer based on the data of Column F in Image...

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

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

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

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

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

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