Is it possible for the new function UNIQUE to be used across various columns & have the output spill into a single column? Desired output is UNIQUE values
If all hours worked prior to 12:00pm on a Saturday are paid at normal time (1.0). Hours worked after 12pm on the same shift are paid at penalty (1.5) So if a s
I am trying to create a formula that takes a selection of choices from a cell and turns it into a "score", then at the end of the row it adds the score up. I kn
I need to replace or substitute the first instance of a single text character in an excel row. current: B01 TEST TEST TEST A W B 0 A expected result where first
In this example, I have two columns of data: Date and Quantity. Example: (See Screenshot Link) What I'd like to be able to do, with an excel formula (if possibl
I'm trying count number of values from another sheet into column O which has same system name as column B and more than Zero. Could you please let me know the b
I want to use COUNTIF function to evaluate how many items out of 2,0,0,5 are greater than 2? In Countif function, first argument is range and second is criteria
Using an Excel formula, I'm trying to pull the MAX value for a NAME that has a certain LETTER next to it. Eg: Highest # for a specific % for each unique Name
I have tried searching on SO, and certainly have not found solution for similar problems, may be I haven't used the right word to search. So, Column A & Col
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