index & small

I am trying to use the INDEX functions to extract multiple data with multiple criteria from different work sheet. But it didn't work, it show empty cells, no error was given about the formula. Please kindly advise and see the formula and table below. A column B Column C Column D Column...

Dear all, have a very nice day I apologize for the lengthy statement, but I want the problem to be well formulated to avoid confusion. In the 'Data' worksheet, you will find information that compiles the weather conditions recorded daily for any given city from January 1, 1999 to December 31...

Hello-- I need assistance with creating a formula that checks to see if column B is blank-- if it is blank then I want it to pull the information in Column A. This will be an on going spreadsheet so a vlookup wont work because i'd like the results to be a concise list of the results with the...

Hi Masters, I need your help again. I was trying to use an index formula to sort the 2 sets of data from a smallest value. I cannot get it sorted how I want the data should look like in my excel. =IFERROR(INDEX(A$1:A$44,SMALL(IF($B$1:$B$44<>"",ROW($2:$44)-ROW($2:$2)+1),ROW($A2))),"") 1ST SET...

how to get data from 4 sheets in another 5th sheet. right now i am getting data from 1 sheet as this formula =IFERROR(INDEX(PAINT!$E$7:$J$406,PAINT!$D128,COLUMNS($B$16:F137)), " ") but how to get data from all 4 sheets???

I am looking for a formula that will find the value in cell B1 in the row B5:I5. Then go down from that date to the first non-blank cell. Then go left and return the corresponding value/name in column A6:A12 into cell F1. Thanks in advance. I have been racking my head trying to figure this out...

I have two workbooks, one where I am doing the Vlookup and the other contains the table I need to retrieve the information from. I am trying to basically Vlookup the table found in the other workbook '[Database_IRR 200-2S.xlsm]Changes'! below row 3 as sometimes the lookup retrieves information...

I have a formula that I am using (after you paste it press "Enter+Ctrl+Shift" to run it as it has an array inside of it): =INDEX('[Database_IRR 200-2S.xlsm]HE 171'!$F:$F,SMALL(IF('Operation base Q'!$H$5='[Database_IRR 200-2S.xlsm]HE 171'!$A:$A,ROW('[Database_IRR 200-2S.xlsm]HE...

Hello All, I am trying to extract some data from one sheet into another based on two different criteria. I need to select the data from the last six months and where column C = 1. So far I have been using an Index and small function. I have been able to extract some data, but not the correct...

I have this formula, I feel I am making a very small mistake, but I keep receiving the #N/A error. I've been working on trying to find a fix to it for about 2 days now, any help would be greatly appreciated. 1 2...

Seems simple enough but i have been unscuccesful DATA: columns NodeName, Weight A1, 800 A2, 800.1 A3,820.9 A4,815.3 A5,801.6 A6,801.6 A7,815.3 you get the idea. very simple data, except i have thousands. I've tried creating histograms and that works fairly well but you can't really see the...

I want to use the function in this link (https://www.get-digital-help.com/2013/12/13/lookup-and-return-multiple-values-sorted-in-a-custom-order/) but the only difference is that I want mine in descending order not ascending order. How do I modify this function to do that? This is the function...

Hello fellow excellors, I have a number of assets that contain very specific suffixes, for example: XRD05_CV XRD06_CV XRD07_CV XRD08_CV_I XRD08_HB XRD08_WS XRD09_CV These assets are listed in a master table. as you can see, there are different suffixes such as _CV, _CV_I, _HB and _WS. Now I...

I have several tables in one tab which I have named individually. In another tab I have a table that I wish to populate with the same information of the selected table based on a drop down selection. All tables are the same size. The dropdown is also a named range. The list in the dropdown is...

Hi Everyone, Would you be able to help me create a formula that will allow me to return multiple results, but then display the cell reference of each result I tried to use INDEX MATCH but it will only display the first match that it finds then return the cell reference of the match, this is the...

i am trying to add another criteria to this formula so that once i copy the formula down it will generate a list. it works with one criteria but i need it to use two. =IFERROR(INDEX($A:$A,SMALL(IF($D:$D=O$3,ROW($D:$D)-ROW($D$1)+1),ROWS($D$1:$D1))),"") how would i go about adding the second...

Hi A have a row with 0 and 1 and they comes in a serial. A wants a formula to calculate the largest/ second largest serial of 1's in a row. I wants to variate were to start and stop, sometimes I have to start counting in a middle of a serial of 1's 1111111110000000111111000000000001111111111...

Hi there, Would really appreciate any help with this! I have 2 sheets: Combined Data and VGBB Summary. The snapshot below is VGBB summary. What I need to do is bring over all of the prices associated with each category (e.g. Accessories) to the right of the category. My issue is that there...

Looking for help in the following: Trying to move data in multiple rows in tab "Colors" to one row on "Summary" tab. Colors tab looks like this: A B C D 1 Red 1 2 2 Red 10 11 15 3 Red 23 150 256 4 Blue 5 6...

Please help I have a spreadsheet that manages queries on a daily basis, each entry is time managed by a userform (ie timer starts when form opened and stops when closed) the start, stop and elapsed time get input on the log. This log is used by several people daily. the formula i have at the...