small index function if

I am attempting to find all values from a power quarry table and return all orders for a specific machine. The return value does not return all values from the combined power quarry table. How do I get around this to grab all?

Hi, I currently have a simple working formula using the Index/Small with Rows to generate a list of jobs a user is working on. =INDEX($C$1:$D$10,SMALL(IF($D$1:$D$10=$L$2,ROW($D$1:$D$10)),ROW(2:2)),1) $L$2 = User I am trying to use the Indirect Function to test finding the data on another tab...

Hello, I have a scheduling task, I am schedueling people in a table, after that I wanted to seperate each team working in each aircraft to be shown in a different table. So I have a two condition, Team and A/C. I tryed to use Index + Small function, but joining the conditions with AND will...

Good Day, I'm trying to figure out how to pull data from my raw data page (Screenshot 1) and transfer certain data to the second spreadsheet (Screenshot 2). I'm having troubles with getting my formula to populate the correct run number. I'm trying to use Index match function. If I select...

I wanted to make a study planner for myself. For that I have created three Excel Sheets namely Schedule, Tool and Status In "schedule" Sheet I have created a table as below <tbody> Slot 1 Slot 2 Slot 3 Date Status Topic Lookup Status Topic Lookup Status Topic Lookup...

Hi I need to figure out the first date a customer ordered an item, i have a very large database output and with customer ID and Order dates, against each customer I need add a cell that states the 1st order date. Raw data example <tbody> Customer ID Order Date 2 1/10/2012 2 25/12/2012 2...

:warning:So please watch this tutorial first http://www.youtube.com/watch?v=R5ZWAiNJLNo&feature=channel_video_title, instead of using =IF(ROWS(D$2:D2)<=$C$2,INDEX($A$2:$A$10,SMALL(IF(ISNUMBER($A$2:$A$10),ROW($A$2:$A$10)-ROW($A$2)+1),ROWS(D$2:D2))),"") Can we use formula...