match

Hello all, I was looking for some help to tweak the code posted by Trebor76 several years ago in this thread: https://www.mrexcel.com/board/threads/vba-to-copy-row-to-another-worksheet-if-cell-value-is-found-in-a-list.1183144/ It is very close to what I am trying to accomplish now but there is...

Instead of =COUNTA(A11:A5000) below formula automatically adjusts to however many rows with data, instead of limiting to 5000 rows, or putting a million rows: =MATCH("zzz",A:A)-10 Tried to incorporate same solution into =SUBTOTAL(103,A11:A5000) with =SUBTOTAL(103,(MATCH("zzz",A:A)-10)) and...

Beginning of month 01/01/2022 01/02/2022 01/03/2022 01/04/2022 01/05/2022 01/06/2022 01/07/2022 01/08/2022 01/09/2022 01/10/2022 01/11/2022 01/12/2022 Net working days 21 20 23 21 22 22 21 23 22 21 22 22 This part data and I have a separate sheet where I am gathering data for each month...

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