frequency function

Hello, I have a report that is extracted daily Mon-Fri. I want to show the unique ticket number (because sometimes is duplicated) that is overdue on the day I extract the report and how many day(s) that ticket has been in the inbox and do that for the subsequent days. Examples: 1) Overdue...

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: <tbody> SSN $Dollars Date 123 $10 10/10/2018 123 $10 10/12/2018 456 10/14/2018 456 $20 10/16/2018 123 11/10/2018 789 $10 11/12/2018 1011...

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)...

Hi 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...

Hello All, 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...

Hi friends, 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 <tbody> A,1 B C D What I expect the results to be: 2 Obligor...

Hello guys, 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...

Hi, I have this function, for simplicity's sake it is provided below: =FREQUENCY(IF(A1:J1<>"", COLUMN(A1:J1)),IF(A1:J1="",COLUMN(A1:J1))) 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...

Hello, 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...

Hello all, 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: Time Temp 0:00 -15 0:15 -15 0:30 -16 0:45 -16 1:00 -17 1:15 -18 1:30 -20 1:45 -20 2:00...

<tbody> A B C D 1 Job# Description PO Type 2 3 5400 311 11st job 4 1101 NC Ward 350.00 deck 5 1102 IL Cotr flex 6 1101 NC Ward 350.00 deck 7 5204 600 Pat Place job 8 1102 IL Cotr 407.00 deck 9 1103 WA Brown flex 10 11...

<tbody> Invoice # Order # Customer # Item # Item QTY 100001 1001 10 XB33 2 100335 1021 10 XB33 6 103009 1103 10 XB33 3 </tbody> 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> E.g.</SPAN></SPAN> Date Product Sales</SPAN></SPAN> 1/1/13 X...

Hi All, 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...

Hi, I need to know how many values in a column match my criteria: Column a:a 1 2 3 4 5 6 7 8 9 10 Column b:b S D T S S S D D D T I need a formula that will go through column b and count how many times the following values occured consecutively. S D answer: 2 S D T answer:1 D...

Hi, 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. Example: WEEK 1 REQUEST1 5/13/2012 5/10/2012 5/14/2012 5/11/2012 5/15/2012 5/12/2012 5/16/2012...

Hi, 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...