Category "excel-formula"

Match text from two different workbooks, return value from different column

I have never been so frustrated with Excel in my life. I'm coming up against two major deadlines at work, and the only way to get the right info to the right pe

Match text from two different workbooks, return value from different column

I have never been so frustrated with Excel in my life. I'm coming up against two major deadlines at work, and the only way to get the right info to the right pe

Group text strings from a list in excel

I am trying to make kws grouping using excel, but my formula is becoming gigantic. I was wondering if there is an easier way to do what I am trying to accomplis

Group text strings from a list in excel

I am trying to make kws grouping using excel, but my formula is becoming gigantic. I was wondering if there is an easier way to do what I am trying to accomplis

Define a lambda function with infinite number of arguments

Some Excel native functions like VSTACK permit of infinite number of arguments, and they have an intellisense as follows: I would like to know how to define su

Finding rows with matching id's and the using the date fields in each row to find the time difference in days between them

I have rows of data where up to 3 id's match. I need to try and find the number of days between each of the rows with matching id's using the date field. I am

Recursive LAMBDA to replace characters by specific substitutes from a lookup table

The goal is to iterate through rows of the character table and replace each character with it's substitute. The character table in this example is ={"&","&a

Is it possible to step through a row of data and sum every n-th cell using a Lambda function?

I have a model that produces an array of values that can be several hundred columns wide. Every 25th column contains a number that I need to add to the total. I

Find certain code combinations using text (sub)string in Power Query

I had similar question (link below), but it just lets say "add-on" to my issue that I found on the way. Find all code combinations using text string in Power Qu

How to list ingredients for a product if one product can have another product as ingredient

Ok, so here is my simple table, P1-P4 = Product, Ix = Ingredient +---------------------+ | A B C D | +---------------------+ | 1 P1 I1 I2 I3

Replacing file path in excel with another

I have an excel file with cells that retrieve data from a file stored on another computer. I need to update the file path in all of these formulas but it is ext

Formula to count number of people of a certain age range and gender

I have a column for age and a column for gender. How can I get the number of people with ages between 0-18 and with a gender of "male"? For example, with the fo

Excel formula to find the rightmost column containing a value in a table

I have some data structured like this in an Excel spreadsheet: A B C D E F 1 1 1 2 x 2 3 2 1 1 1 2 2 3 3 3 3 3 3 4 4 I am trying to formulate an E

How to use COUNTIF to count colors of cells under conditional formatting?

I am trying to figure out how to structure a countif formula. I have a table of data along with (broadly speaking) two sets of conditional formatting: - for the

Other Categories