I have a spreadsheet which has a lot of duplicates I need to cleanse but need to ensure the right data in another column is kept. Data and desired outcome Esse
My workbook has two sheets, we will call them Summery and Events. In my Summery sheet, it looks like this Name Last Event Name 1 Event 3 Name 2 Event 15 In m
I have an array of non-ordered integers, and I am trying to return a TRUE or FALSE based on if x consecutive numbers can be found within the array Example array
I have the following range of values: National museum of Natural History Archaeological Museum, Art Museum, Agricultural Museum, Marine Museum National museum o
I'm designing a datasheet that updates itself automatically. All of the macro code is working properly, but I have trouble locating the place where the data sho
Please note that my question is closely linked to this question. However, as the above question is technically already answered in the comments and I am still v
I need to create a running product from a column of numbers (I could use a row, but a column is easier to demonstrate here.) The input might be any arbitrary a
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