I am trying to convert a field in an excel sheet (e.g. REC_LEN) to camel case. I am using this formula to do that =LEFT(A1) & RIGHT(SUBSTITUTE(PROPER(A1),
I'm attempting to calculate periods of out of stock for a fleet of rental equipment that has been in service for the past few years. I'm having trouble creating
Is there a command in Excel to check if a set of rows is directly equal to another set. For instance I want to check if the values inside rows 1 to 10 is equal
I'm trying to find the column number using a =match formula. In particular I am looking for a result of 42. As you can see, the formula looking in row 16 finds
I have one column (E) trying to change the Arabic characters to English one. these data i import it as it is from JSON file. How to change these Arabic characte
Private Sub CommandButton1_Click() Range("C10").Select For Range("C10").Value = 0 To 35 Range("C10").Value = Range("C10").Value + 1 Next En
Here is the column entry for A1:A24 0,092 0,045 0,015 0,046 0,041 0,027 0,073 0,004 0,020 #N/A 0,000 0,001 0,004 0,000 0,032 0,000 0,002 0,140 0,005 0,001 0,251
I have a big function with lots of branches of IFS; each branch uses different references of the worksheet: MYFUN = LAMBDA(i, IFS( i = 1, // a formu
How can I display desired data "Description" according to its given specification? I got to fill up yellow boxes. Formula only
| A | B ------|-----|-------- 1 | x | 1 2 | y | 2 3 | z | 3 4 | a | =B1*B2+B3 Imagine the above stuff is part of an ex
This question will seek multiple approaches LET/LAMBDA VBA UDF and Power Query Function, so there will be no single right answer, but a solicitation of approach
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