match

I have this question posted over at excelforum also and so far for the past four days there has been no help. Help with VBA to input data into a second sheet using formulas I really have no idea where to start trying to stitch something together for this. I have a Honey and Honeybee business...

Hi everyone, Here is a question for true experts who love a challenge. Unfortunately, I can't figure it out. I have a list called 'Sales'. This is contained in a Named Range 'RngCalDays' = Purple (incl. headers). The list contains (consecutive) months in the columns and sales quantities in the...

Hi, New to this forum so hope this makes sense. Is it possible to use LARGE, INDEX and MATCH together in a single formula with no helper column? For the above: I need to be able to have two groups of 4 names from any of the 8 names. Group 1 and group 2 are just examples I have chosen but...

Hi, I have two data sets. I need to pare down the larger by the smaller and return a new data set with the values that match between the data sets. Data set 2 needs to be filtered to only show matching results from data set 1 based on contract # and project id. PLEASE HELP - I am way past due...

Hi, I have the following formula to find the max and min value in a column: =(MAX(Data!B:B)&" - "&MIN(IF(Data!B:B>0;(Data!B:B)))) But I want to find the corresponding cell in another column using index and match. But I can’t figure it out to find the smallest value greater than zero in this...

Hello, I'm looking for a way to pair two lists of names randomly that do not duplicate. In column A) I have 6 names, and in Column B) I have 12 names. Column A would then be paired with two names from column B. Is this at all possible? Thanks for the help!

Stumped myself with this one. This one has had me for hours. Tried 4 or 5 different formula but still cannot for the life of me get it to work. So looking for a formula which will do the following. 2 reference dates for new staff members - and their efficiency Start Date - Column B - rows 2...

Hi I have reposted this as my previous entry was confusing and un clear. I am trying to Match data and pull data from one sheet to another. Worksheet "Attendance_Input" calculates percentage attendance across the row. The example below shows the December attendance for Liam Smith as a...

Given this array {0,1,0,0;0,1,0,0} I would like to return the number 2 for the column number where both rows contain a 1. I tried XMATCH(1,{0,1,0,0;0,1,0,0},0) and even XMATCH({1;1},{0,1,0,0;0,1,0,0},0) but none of them worked. Any help would be appreciated

Hello all, unfortunately I can't get XL2BB program to work, so I'll try to describe my issue. It is likely an easy fix but I just can't seem to wrap my head around it. LineValue LineValueUnique? FIBER DSL 029860000 COAX I/E-KUNDE 028020000X TASTET AF...

Hi I'm looking to find formula to return a value in sheet 2 after searching for a specific product code and month in sheet 1 and matched to the date in sheet 1 for example find the price paid for an ingredient in October 24 Thanks in advance

ISNUMBERS checks if all elements of the reference are numbers and provides a single logical output, with options for checking if the reference is a single number or equal to another set of numbers and extending equality with elements of other data types The output of ISNUMBERS is always a...

I'm working with a dataset that has two columns: Transaction (Column A) and Client ID (Column B). I'm aiming to extract the Client ID values associated with a specific Transaction from Column A. For example, if I select Transaction 100000223, I want to retrieve the corresponding Client ID...

I have a budget workbook which, along with other information, I import data from various financial institutions every month containing "Transaction Details" which I need to categorise and allocate. The data is never in a consistent format and the information I need to categorise against the...

Morning folks - hope you can help. I'm trying to create a hyperlink that goes to "today's date" when the date rates sits in one row over multiple columns. I've seen some videos on you Tube but the all seem to list dates in rows, I've tweaked the formula but it comes back with "Reference isn't...

Hi, Greetings for all! I have a formula at Sheet2 as ...something(from this beautiful forum)..Sheet1!$A$2... When I insert 10 rows in Sheet1, formula in Sheet2 changes into ....Sheet1!$A$12.. How to prevent/fix formula to $A$2, how to fixate it to A2 Thank You in advance!! New Micro Excel...

Hi I am trying (and failing) to pull specific data from 1 sheet "LOG" to a "Request Form" using a sequential number as the guide reference and when the sequential number is changed on the Request Form all the date is entered from the corresponding row in the Log. The data will be inputted...

Hello, I am trying to itemize expenses by division of operations for my farm. I have a list of every expense made throughout the year. I need it summarized but flexible enough to account for differently named items that may be purchased in the future. Per my image uploaded: I am looking to...

Hi I need to horizontally look at a data set & return the date of the most recent sale. in this example, 2 sales occurred in April 2024, so cell A2 returns 4/30/2024. A3 returns 1/31/2024 b/c 3 sales most recently occurred in Jan 2024. A1 return Formula 06/30/2024 05/31/2024 04/30/2024...

I have a data set that includes alternate SKU's for products. The alternate SKU's may be in any one of 31 different columns. I have a list of alternate SKU's that I want to look for i the range. When found, I want the formula to return the corresponding value in a different column. This will be...