index

Backstory: I have two companys that I am trying to merge into shift tracking system. We have over 200-300 clients and 500-600 projects per year. The file only shows 2 clients I made this work one way where I had two master lists of projects based on company names and the cell values for...

Hello, Column A is filled with string values. Column B is sometimes filled with the value "x". I would like to write VBA code that returns all the string values from column A into an array if they match the "x" value from column B. Anyone knows how to do this? Thanks

I am working on putting a template together for my company and ran into a problem with having two dropdown lists. The goal is to have that ever is selected in list 1 to populate only a set list of items for list 2. The spreadsheet attached i am working in column 'H' & 'I'. the code form column...

Teams Dropped Passes USA 5 Canada 1 Japan 5 So this formula: returns "USA" which is not completely correct. How can I get it to return:

Hi All I am writing a code in VBA to index and match against a date which runs in each column, and returns down each row. I can do this for each row if i write it for each as attached, is there a easier way so that it loops rather than me having to write multiple macros? ''' Sub test2() Dim...

0000378G FCP1 or FCP4 € 39.44 0 € - 0 € - 0000447G 0 € - 0 € - 0 € - 0000450G 0 € - 0 € - 0 € - 0000458G 2.01.03 € 70.47 2.01.07.01.02 € 375.75 2.01.07.01.02 € 228.13 So this is example of my data. Now i want the addition of the amount for each value (2.01.07.01.02) for each ID. I...

Hi, I have a problem that I could use some help solving. I have an Excel workbook that calculate prices. The workbook has about 250 different products. All products are priced based on measurements, both width and height. The user enters the product number, number of products, width and...

Hi, I am looking to fill in the matrix on Table 1, referencing criteria in Table 2. I have only included a sample of total data. I want to INDEX column 4 in Table 2 so that the matrix in Table 1 specifies which stage (1, 2, or 3) is happening and when it is scheduled. To do this, I want to...

I have been using an awkward method to store and call my UDT arrays by key. That is by making an array and corresponding collection for storing the array index and calling the content by key, please see my code below. Is there better practice for this in VBA? That maybe can call array member by...

worksheet table y x 0.1 0 (0.1) (0.2) (2.3) (0.2769) (0.1216) (2.4) (2.5) 0.0167 (0.0624) (2.6) (2.7) 0.0698 (0.1279) 0.0923 (2.8) 0.0692 (0.1111) predictions formula used...

Hi Community, is there a way to get INDEX to work with multi-column select dynamically. This Works: INDEX(Table,,{3,5,9}) This Throws an Error: INDEX(TABLE,,{COL_A,COL_D,COL_C}) EDIT: Just an FYI; this also works: INDEX(TABLE,,COL_D)

Using google sheets, is there a way to look up a value on the vertical & horizontal axes between two numbers? If years of service is 2.8 and company growth is 18.8, how can a lookup formula return 10%? We are rounding down on both years of service & company growth. Company growth: greater...

Hi, I have 2 Sheets(workbooks in reality but I made the test sample in 2 sheets). DATA sheet: All text/numbers. No formulas in this sheet. RESULT sheet: CFGMNOP1IDItemBalanceMatch Failed (Accessorials)Invoice Rejected (Accessorials)Approval Failed (Accessorials)Amount Due233283896Stop-off...

I have a list of suppliers that goes on a rolling basis. I'd like to be able to know which suppliers are next in line based on when they last accepted as it should go the longest waiting and if they are available. Supplier Status Date of Last Accepted Test 1 Available 31/8/22 Test 2...

Hello, May I ask for some help resolving this query please? I seem to be making an error when I am trying to exclude one field if there is data entered. I will explain further below. I am looking at some data with a series of dates. The dates are used to determine if the submission should...

Hi all, I am currently trying out this formula: Copy of my formula: =if(A5=Left(A5;5)="Bob G"OR(A5=Left(A5;5)="George G");"This formula works!";"This formula does not work!") Essentially, what I want to achieve is for my formula to return "This formula works!" if the value in cell A5 is...

Hi all, I have this file that was converted from PDF to Excel. I would really like to filter everything in column A by date However, when I do it looks like this: It filters down until row 687 The row looks like this: I have no idea why it stops? It used to stop at points like these...

I feel like I'm going around in circles between index and more. I have multiple sheets, but for this example just set up the two I needed as they would appear in my workbook. I am trying to make it so that if I select a student's name from a drop down in Column A on sheet 'Student Report' (first...

Hello everyone, I'm trying to extract data from sheet1 into sheet2. One of the columns in sheet1 contains a personal identifier along with other text. On sheet2 I use a filter function to extract data from sheet 1 by referencing cells in sheet2 column (i) that lists the personal identifiers...

Hello I'll try and keep this simple. Sheet 1 This is a list of absence. Each separate occasion of absence is recorded against a unique employee ID in Column A and on it's own row. On each occasion, there is an absence start date and an absence end date. Example: an employee with 2 separate...