match

Hi, I have the following code which creates an array "Ary" with string elements from a table column that match value "x" from another column in this table. I would like to have cell E6 display a randomly picked string element from this array "Ary". How would I have to alter the VBA code? Sub...

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

Hi, I have a set of data with a non-unique numerical ID. However, the column "Name" can be considered unique. Please see below. The cell reference of "Order ID" is B1 and the bottom right cell is G15. Order ID Name Poule Number Victories Prop Indicator 845.3333333 James 1 5 0.83 12 497...

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:

I have a computer generated list of skills for 60 candidates. The goal is to build a table that tallys the skills across all candidates to determine which skills are most frequest there most important. However the list of skills I have for each candidate is messy. For example, Candidate A...

Hi all, I'm just trying to find a simple code that pops up a msg box saying if all the values of one range are matching all the values of another range or not. I know I can do that with a formula, but I need to do it with vba because I might use it in another applications...

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'm hoping someone can help me or tell me it's just not possible! I'm trying to create an automatic stock checker by entering a list from our system versus external location reports, once I've entered the data I can only seem to show if there is a match but not which item, status or where...

Hello -- thanks for reading this post. I am very stuck on this problem i have attached an image to explain better - i need to check Column B Title and Find all Exact Matching values from other Columns C D E F (attributes) and give an output In Column H I J K - in order to find out which sku has...

Hello, I have tried everything but cannot find a solution, I am really hoping someone can help with this. I am looking for a macro that will look for duplicates in the same row across all worksheets. Each worksheet has the same style as the one below, I just need a macro that will look in each...

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...

Hi folks, I thought this would be simpler to figure out...but I can't quite get the result I'm after. Mini-sheet attached. Table has Population, Run (First, Second or Third) and a Sample Value. Goal: User selects/enters population letter in G2, this returns in H2 the sample value from the...

Hi, I've got two workbooks ExtOrgsList.xlsx contains an ID of a Customer. The ID is in Column A and the Customer name is in Column B. Destination.csv has column AN which contains the Customer names. The code below works but if there's any deviation in the name it returns the partial match...

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...

Hi, I'm trying to find a formula that will help with the below conundrum (sorry for not using the XL2BB, but I don't have permission to download on my work laptop). Basically, The criteria can be found in cell B7, B8 and B9 and the correct result of 3 has been returned in cell B10. What this...

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 all, I am trying to reference a cells value in a formula I am trying to use, however I do not think it is working because the cell I want to reference has a formula in it, which is then formatted to give a specific number. E.G. Cell B2 has the value I want to reference in my formula...