I've been racking my brain all day on this one and desperately need someone to swoop in and give me the answer. Data is set up as follows:
I have a column of data with varying length and I use the formula below to return a value. Is there a way to have excel determine the last cell in the column without using VBA? My assumption (I've tried a few times) is to use INDIRECT, but it keeps returning a numeric value (column is names)...
This is me first time posting on this forum, so hoping someone can answer.
I have data in the below sample format. I am trying to get a record count when the values in column 1(Week) and column2 (Name) match together. For example, User1 has three entries for 7/14/2018. So in column3, I...
I would need someones help with frequency formula. never used it and now i need it for some of my work, i can come up with basic one but not with one with multiple criteria.
So here is what i need help on, i have a document with persons working times. Based on that i need to be able...
New here and really hope someone can help. This is for a work challenge so is super important to me. I have never created a macro in excel, though I'm almost positive this is the only way to get excel to perform the task.
In my workbook I have price data for a stock by day (I am...
I have a financial modeling issue I can not solve.
I am seeking:
1. The number of unique obligors with a senior debt principle value investments >0
2. The number of unique obligors with a principle value investment >0
What I expect the results to be:
I am using this formula =SUMPRODUCT(--(FREQUENCY(IF(D3:D38>=5,ROW(D3:D38)),IF(D3:D38<=4,ROW(D3:D38)))=5)) which is an array to identify every 5 consecutive numbers above 5.
The only problem is if there are more then 5 consecutive numbers and not exact 5 then it wont return...
I have this function, for simplicity's sake it is provided below:
Cells A1:Z1 are populated with a series of number with blank cells in between them, and the function above calculates how many cells are in a row until a...
I am having issues calculating the maximum number of successive data in an array. I do have the formula for calculating the max number of successive data in a single row.
However, my issue is I want to use that formula and apply it to rows below row 2 and beyond and have it return the...
I am trying to create a single formula in a single cell that lists the number of times an out of specification condition occurs for greater than two hours. As an example:
600 Pat Place
Very small sample table. But let's say I wanted to add 2 columns to this.
The first one would be labeled: Reorder?
What I'm looking to...
Using frequency in a data validation formula for ensuring unique entries.
Currently I use COUNTIF($B$2:$B$244,B2)<=1 or ISNA(VLOOKUP(A9,A$1:A8,1,FALSE)) to ensure all entries in particular columns are unique, but I have heard how slow these functions are and that the Frequency function...
I have a data table that registers daily sales and there are several sales per day. I need to create an array function that groups sales into single days. </SPAN></SPAN>
Date Product Sales</SPAN></SPAN>
Had to know if the frequency array function can be applied for a text which we can by using the following formula "=SUM(IF(FREQUENCY(IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""), IF(LEN(A2:A10)>0,MATCH(A2:A10,A2:A10,0),""))>0,1))" which gives the unique occurrences of text in column A...
I need to know how many values in a column match my criteria:
I need a formula that will go through column b and count how many times the following values occured consecutively.
D answer: 2
I am working on a workbook to help me schedule vacation in my department. One thing that I am having trouble with is getting excel to return the number of days that exist in two different lists.
WEEK 1 REQUEST1
Struggling to get the Frequency Function to work with time.
In Column B i have dd/mm/yyyy hh:mm this is exported from a Database.
I want to know how many cases arrived between each hour of the day.
I've used Text=(B2,"hh:mm") and also tried Text=(B2,"hh:mm:ss") to extract the time...