I need to write some VBA code which could give me the result in the "Sorted Numbering" column in the below picture: The logic for the sorting is that filter th
I want to count all the instances that "a" occurs in column a AND "b" occurs in both column b and c. This would be in a match up style. Essentially I am trying
How to extract / filter an inventory list (in range B3:C7) based on a lookup list with partial strings (in range F2:F3)? I know that if the filtering strings w
My dataset looks like this: I am looking for a formula to add to the column "Status" to do the following: If Name = "A" and Project = "TT" and Number > 5, w
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