index array

Hi, I am trying to determine if I am using the correct type of formula and figure out why I am getting an error with the formula I am using (maybe I should use a different formula completely.. such as an index or some sort of array or a if... IDK). I need to search column C row 1:556, on...

Whenever I entered a new name in sheet Enter Data the values itself duplicate in summary sheet, how to avoid this? Here's the link of my sheet. Thanks https://drive.google.com/open?id=1fGWYlOa1ZnQaSqOQC8FShFcD4D48gu91

After much scouring of the threads I have found nothing similar enough to this that I can steal from. I am trying to pull Space and Manifold ID from a chart on a separate sheet based on the date the manifolds were repaired on. The manifolds and space repeat a lot as there are multiple valves...

I would like to transform the table below: <colgroup><col span="3"><col></colgroup><tbody> Events Location coach cleaning 1-jan A John 2-jan B Mike Suzan 2-jan C Nick Jenny 3-jan D Ralph 4-jan E Nick Mike 4-jan F John Suzan </tbody> To the following table...

Hi Guys, I have a formula that seems to be pulling the information I need well, but it functions very slow and it is an array formula. I am looking for an equivalent formula that is not array. {=IFERROR(INDEX('2018 Import'!$H:$H,SMALL(INDEX(($A$9='2018 Import'!$A:$A)*(MATCH(ROW('2018...

hi, I am trying to do an index match for 2 criteria. Lets say i have to return a random number from column C. Matching criteria 1 is DEF and matching criteria 2 is 01/11/2021 (I'd like to match the closest date). So ideally I would return Random(6). A B C ABC 01/01/2020...

Hi folks, I am stuck and am hoping you can help. I have given up on budgeting software and am attempting my own Excel version of a budget for my household. In a worksheet, I have downloaded all of our bank activity for the year. Many of the transactions are repetitive, but the bank reference...

Hi, In sheet 2 (Input) I have a table from A2:B200 with dates in column A and values in column B: In sheet 1 i will have two tables A2:B200 Date | Negative values G2:H200 Date | Positive values These should be populated from the table in sheet 2. I got this formula (don't look at the cell...

Hello: I have a report that is being dumped into excel. From that data, I have a Index Formula that is returning data based on client. When that data returns I need to be able to filter by date. I need to be able to type the date range in two separate cells. <tbody>...

I've been trying to understand the array vlookup approach and have not been successful. If I have a list of item codes and I want to return a list of the unique items horizontally If starting in B2, I enter this table: <tbody> Category Item Coffee Espresso Coffee Espresso Coffee...

I am trying to modify the below array to determine if a date and PO number have already been returned as a result for a date then skip to the next PO. see the attached screen capture which is returning the same PO number multiple times in the calendar. I'm using named ranges (CalList, PO_Number)...

Hello, My query is that I would like to use Index and Match functions that relate to the Date and Code criteria as per query below. It can be assumed that the data box below starts from cell A1 to C8 and the criteria box from E1 to G8. The formula I have been using is the following...

I am building a report which needs to display all entries on a separate sheet where the entry falls into a date range. Sheet1 (report) The start date is in B3. End date is in D3. Sheet2 (data) Dates are displayed in column B. Array to pull is Column B through AU. So, if the start date is...

Hi Experts!!, Pls. Help me.. I've followed a lot of exmaples here and tried different combination of MAX, IF & INDEX functions..even trying to nest MAX inside of Index but it doesnt work. Im frustrated and I cant seem to get a reliable formula to work consistently. I've attached my sample XLS...

Hello, I'm having trouble with my index formula.. Situation: First table is data, second table is calculation column A B C D Table range is A2:D6 <tbody> GSSE GTRS D 70417 50 100 D 160784 150 200 C 70417 250 300 C 160784 350 400...

I am creating a master sheet to analyze 6 other sheets in a workbook. All the sheets are formatted the same and have the same layout. I am trying to pull the entire row if one the the cells values is 0. I have used an index small feature before to do this with a single sheet but do not know...

I would like to search 5 unique product sheets (one at a time) through a drop down selection interface on a separate sheet. The search is based on 4 input criteria (length, width, height and mass) and match the closest record containing the next largest dimensions across these 4 individual...

Looking at this image: View image: ex 4 I want to be able to in cell C2 have a function that looks at Cell B2 and if it says "Yes" look at Cell B1 and it it reads "No" return value A1. For cell C3, what should happen is that it looks at B3 sees "Yes", then looks at cell B2 sees another "Yes"...

Hi all, Below is the part of the dataset I have. As you can see, there are 4 columns: Model, Sequence, Applied Date, and Expected Cost. Each model has different sequence numbers and each sequence numbers have different expected cost. What I want to do is to extract only one corresponding...

Hello, I am having an issue with Excel. I got an array-index formula on one sheet (SearchSheet) that returns values from another sheet (DataSheet) based on date or name searches-inputs. So if I enter 15/5/2015 it will return all the values from my datasheet, whose dates are the same or the...