match and index

I have a spreadsheet of students assigned to a specific teacher on a specific day for tutoring and I would like to create a single sheet that list all teachers individually in a row and then shows the students assigned to them for each day. I have tried VLOOKUP, MATCH, INDEX with no luck. Data...

Hey Guys, Would really appreciate your help on this. I have percentages sorted from low to high in rows. They might be repeated many times. My first row contains time slots. I want to return the first matched percentage and corresponding time slot for % greater than 67% and less than 99% Eg...

Hello all. I have a project Dashboard that needs to refresh the Daily Numbers in order of Order Volume. Then, after I supply the number, I want to application.worksheetfunction.match/index the client associated with that Nth Large number. Only match/index isn't working for me as there are...

I have a project where 60K records from the original worksheet have duplicate client # numbers. As in, the client placed multiple orders using the same client project key but we supplied different transaction ID's. The client has asked for report showing the difference in MARKET price...

Hello! Me again:) Never stop asking questions:) I need formula to EXACT compare rows from different sheets and different row ranges? I have another formula wich serve me when i need compare two identycal ranges(tables): {=AND(EXACT(A1:D1,G1:J1))} double click to copy down, wich is great...

Hi there, I am hoping someone could help me come up a formula that would allow me to find a cell in a range of both columns and rows. I am trying to find an address say "123 New York, NY" and then return who lives at that address. The trouble is "123 New York, NY" could be anywhere in the...

<tbody> Cubic Local $ Outer Area $ ShortHaul $ Longhaul $ InterIsland $ 0.003 2.00 4.00 6.00 8.00 10.00 0.005 2.20 4.40 6.60 8.80 11.00 0.008 2.40 4.80 7.20 9.60 12.00 0.01 2.60 5.20 7.80 10.40 13.00 0.012 2.80 5.60 8.40 11.20 14.00 0.016 3.00 6.00 9.00 12.00 15.00 0.02 3.20 6.40...

Hi there, I'm looking for a formula to match a value within an array and return the results found. I know how to you use vlookup/match/index formula's, but I can only return the first match found. I would like to return the first match in cell B2 and the second match inside B3, third inside...

Hi there, I'm looking for a formula to match a value within an array and return the results found. I know how to you use vlookup/match/index formula's, but I can only return the first match found. I would like to return the first match in cell A1 and the second match inside A2, third inside...

I have a workbook where I am importing data from 2 external reports (CSV to Excel format), and I have to find matches between both reports to determine matching criteria. Once I have this match completed I am pulling the results into another worksheet (all same workbook), for displaying in a...

I have a workbook where I am importing data from 2 external reports (CSV to Excel format), and I have to find matches between both reports to determine matching criteria. Once I have this match completed I am pulling the results into another worksheet (all same workbook), for displaying in a...

=ROUND((SUMPRODUCT(SUMIFS(Import_Balance_Sheet_I_and_E[TRANS_AMOUNT],Import_Balance_Sheet_I_and_E[NOM_CODE],U11:DZ11))),0) The above formula works great, never any issues, however, there are thousands of them and as such it's slow. I'm hoping there is an alternative to having to specify the...

Hi, I have a 684x684 data set for daily retention metrics thats that I want to consolidate into Monthly. <tbody> 1/1/15 1/2/15 1/3/15 1/4/15 ... ... 10/27/16 10/28/16 10/29/16 1/1/15 10 9 8 7 6 6 3 2 2 1/2/15 - 12 10 8 7 7 4 3 2 1/3/15 - - 14 13 12 11 5 4 3 1/4/15 - - - 16 15 10 6 5...

Hi, I'm stuck with a Match INdex formula. In the example above, how can I get the fruit that matches with the date to appear in column G? Is Match Index the right formula or is there something I could be using? Cheers!

I have a table that looks like the one below with the dates sorted in descending order. Person Date Number Jose 1/1/2014 98 Rosa 5/14/14 47 Jose 6/1/14 3 Rosa 2/1/15 456 Jose 12/5/15 3 Rosa 5/2/16 -10 I want to enter a name and date and have excel search...

I am working with a sheet where I am doing an Index/Match where I pull data from a master sheet onto a separate sheet if it meets the two criteria it needs too. I know the Index/Match will only return the first instance but I read online that you can add count function to a column in the sheet...

I have a master sheet that pulls data from 6 different sheets using an index function. I need to have a the first column on the master sheet display what sheet the data came from. I know I could just add a hidden column to the first column of each individual sheet and have it pull through but I...

Hi, I have what I think is a pretty complicated task that I am trying to find a resolution to. I receive a form like LTest from every sales order, I would like to copy certain data from LTest and copy it into 2016 Test 1. Each form is formatted the same and I want to use the data in cell B3...

This is my first time ever to post in forum. Please forgive me if I do something wrong. Okay, here is my question. I currently have a spreadsheet that contains roughly 10K rows and 25 columns. There are two columns in this spreadsheet I want to make use of and they are item number and bin...

I have a table consisting of 5 columns: time, customer, status, amount, and end balance. I'd like to create a report that shows: name of customer and end balance. Conditions: only show the end balance where the status is "success". Please help, thanks.