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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.