multiple matches

Sum INDEX-MATCH Across Multiple Columns with the Same Heading Hello - how - wondering if someone knows how to modify this formula to account for multiple rows could be a match? Same Data but now multiple rows and multiple columns match? instead of...

I would like to get all values matched the Green marked Bank Name column, but it isnt working. I need a swift, easy and permanent solution. BTW the I am working with is huge. its just for a demo. Please help.

Hey, I have read some similar threads here and tried some of them but still no solution for me. I have a large database where I would like to list all destinations of each driver for certain days. The main challenges are 1. any driver can appear in any of 3 columns, 2. there can be more than...

Hi guys, I am looking to effectively extract multiple matches without array formulas as the lookup array for the multiple matches is large and slows down my workbook too much. I have the values, lets call them 'account names', I want to match with as column headers, the lookup column is in...

Hello! I am trying to make a sheet that pulls accrual values. I want to pull text based off of a cell that contains a company name. However, there are multiple lines with different accruals for the same company. I want to pull a specific result (not multiple result). i.e.- I have a carpet...

Hi all, I have two different measures (measure 1, measure 2), in two different spreadsheets (sheet 1, sheet2), with different values. These measures are carried out for each study participant (David, Maria and Bob) several times on different dates. I'm trying to bring together the dates of the...

Hi all, I need help with a project i'm working on. I have a sheet where I need to find and print worksheets based on weather that PPM is needed to be completed that month. So for example, to Print all ppm's to be completed in week 6. I'd enter week 6 in the box and it looks up this week number...

Hello, I have two tables. One labelled "Records" and one labelled "Comments". I both tables I have an "Account Number" However in the records table, there will only ever be one record for each account. In the comments table there can be any number of records for that account. The idea...

Hi, Sorry I'm new to VBA and having trouble with a macro. I have one workbook with two sheets (sheet1 and sheet2). Sheet one has a list of information in a number of columns and column A is the file number for each set of information. Sheet two has only file numbers. I'm looking for a macro to...

Hi, I am trying to find INVOICE ID for all Invoices shipped for each SKU after a certain cut off date. I have a list of over 1000 SKUs with multiple cut off dates for each SKU in Sheet1. The invoice shipments data along with the dates is in Sheet2. I have tried to create a Pivot table and used...

Below is the formula that I'm currently using. When entered it returns error message: "Did not find value '1300' in MATCH evaluation". What am I doing wrong? The 'Bedrooms' column (S2) should equal "3 BD From". Please advise. Thank you...

My brain hurts :) I hope I typed the match array correctly for this example. How do you change this formula so that the result in column E shows the next occurrence on the sheet when there is identical cells in the matching formula? I have a sheet with addresses I'm matching to another sheet...

Dear Excel Experts! I really need your help :) I have an excel file with many different orders. In the order two things are important: values in column C ASHEET (ending on A) and values in column D (components of Asheets). Now i need to analyse whether the component of an order is on ONE of...

I am trying to design a PO that will "suggest" possible materials that match certain criteria. Our company orders many different types of metal components that make up steel buildings. The components have different shapes, finishes (grade and/or types of paint), colors and thicknesses (gauges)...

Hi all! Long time lurker...first time poster. I'm not an excel expert, but certainly not a noobie. So this is very, very frustrating. I have a very large dataset -- around 25K rows (probably more). I have a bunch of fields including STATE, AGE, GENDER, and RATING AREA. In addition, I have a...

I am working on a pressure loss calc worksheet and need to have an index match formula return the smallest/largest value from the matches. I have replicated what a typical sheet would look like below. Each Pressure In cell has the formula...

I want to check if cells C1, D1 and E1 contain the same name. For example if the cells all contain the 'Joe Bloggs' (or whatever the name variable happens to be) then cell F1 should say "Yes", else "No". Anyone out there who can help? Much appreciated!

HI I need a macros for multiple matches in different sheet and need to return the all values for unique id I put an example case for you Sheet 1 contains unique ids and values .Values will repeat In other sheet also values will repeats and will value corresponding values for the each...

<TBODY> A</SPAN> B</SPAN> C</SPAN> D</SPAN> E</SPAN> 1</SPAN> 2</SPAN> Markets</SPAN> Markets</SPAN> Location Name</SPAN> 3</SPAN> Select Market here ></SPAN> 058 - Total Canada Market </SPAN> 063 - Total Northeast Market</SPAN> 064 -...

Column J (J17:J999) & column K (K17:K999) contains values. In column N starting with N17:N999, I want column K values PROVIDED J17= X1 AND K17 = Y1 AND J column does not have blank or null filled thr' a formula "" AND K column does not have blank or null filled thr' a formula "" How to do...