match

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

i have been trying to solve the following issue: i have a very long column of values (in this case there are only two values = FY23, FY24, with FY23 always coming before FY24) and another column values (all zeroes except one value >0 in an FY23 row and one value >0 in an FY24 row) i want to...

Hi All, First time post but I am completely at a loss where I have decided to ask the internet for help. I have two sheets I am working with and want to populate a cell depending on some conditions. E.g. If cell A1 of sheet 1 matches cell B2 of sheet two then cell B1 of sheet 1 will populate...

Hello Excel team. I'm looking for a simple formula that matches numbers between sheets and displays a value from another cell from one of the sheets. For example I have a number in B3 on sheet 2(B3 is constant-$B$3). I want the formula to search for the same number in sheet 1, column B and...

In excel, I am using this formula: =IFERROR(INDEX(Master!$G:$G,AGGREGATE(15,6,ROW(Master!$G$3:$G$98)/(Master!$H$3:$H$98=$A$13)/(Master!$I$3:$I$98=$B$6)/(Master!$J$3:$J$98=$A$4)/(ISNA(MATCH(Master!$G$3:$G$98,B$12:B12,0))),1)),"") The formula checks Master sheet and returns a value from column G...

Can anyone assist with unpuzzling what I did wrong with this formula? I am still learning how to create MATCH and INDEX formulas. Because of the vast amount of information in the file I would prefer not sharing the cleaned file because of how long it would take to scrub it clean. If I must, I...

Hi, I am using the following formula to pull names from another sheet that meet a certain criteria. It will only pull a name once, before moving onto the next match. However, for each name pulled, I want to add the word " Replacement" at the end of it. Is that possible? The formula I am using...

I have two sheets: Master sheet Supporting sheet I am trying to pull any names from column G in Master to column C in Supporting but only if the row meets the following requirements: The values in columns H, I and J in Master match the cells A11, B10 and A4 in Supporting. I only want it to pull...

Hi all, I am trying to create a formula which finds the most frequently occurring text value (all entries all text) in an areay I am using INDEX(D4:D7,MODE.SNGL(MATCH(D4:D7,D4:D7,0))) but this only works for single columns or single rows not a 3x3 or ZxZ array for example Can someone please...