I am trying to create a formula that returns the concatenation of two arrays of different lengths. I need this concatenation for part of anoth
I'm using MS Excel O365 Business in version 1905 (compilation 11629.20196). In this case i have created two sheets: 1) "Orders" 2) Order_status NUMBER_ORD
I would like to write a user-defined function CHOOSERANGE that returns a range from 4 coordinates. The first version is as follows: CHOOSERANGE = LAMBDA(row_min
I am trying to create an if-vlookup that retrieves data from 2 sheets with following specs: if the retrieve from the 1st sheet shows N/A and 0 results than vloo
So say A1 - A8 contain values 11, 120, 321, 435, 623, 765, 964, 1039, B1 Contains a value of 1375 how could use a formula or macro in excel to work out how many
In an Excel formula, is it possible to get a custom document property without an external add-in or help from VBA code?
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
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
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
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
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
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
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
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
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
Ok, so here is my simple table, P1-P4 = Product, Ix = Ingredient +---------------------+ | A B C D | +---------------------+ | 1 P1 I1 I2 I3
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
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
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
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