occurred

I would like help with the following ... Let's say events occur regularly, say every 90 minutes, starting at midnight. Given two timestamps, I want to calculate how many times the event occurred from time 1 to time 2. Some examples: 00:05 - 01:25 (1 hr 20 min): The event did not occur at all...

Hi guys, Hopefully there is a simple solution to this problem. I would like to create a list of dates in a column based on the results of the data in another column. So, In col A i have a range of dates that are random dates from throughout the year. In col B I have either a 1 or a 0...the 1...

Hi everyone, I built quite a large Excel model (280mb) as part of a company project. The model due to its size was a little cumbersome and slow to work with, but it worked well for its purpose. However one time it crashed, and when I reopened Excel after that instance, the error message "An...

Hi, I've got some data which is assigned to a raw value, eg: Strongly Disagree = 1 Disagree = 2 Neither Agree nor Disagree = 3 Agree = 4 Strongly Agree = 5 Lets say my raw data is as follows: Data point #1 : 2 Data point #2 : 3 Data point #3 : 2 Data point #4 : 1 Data point #5 : 5 For...

Hey guys, I have an issue I can't seem to figure out how to accomplish. I have two tables of transaction data. I want be able to look up if a certain transaction on table 1 (We'll Transaction A) is on table 2 BUT only if it occurs within 30 days of transaction 1 AND is within +-$500 of...

Good morning, I use a userform to add lines to a workbook. The file is a shared document and the likelihood is I already have it open but due to the number of open files it's often not easy to see if I do. I am trying to use the below code for if I already have the file open. However I am not...

Hi I wonder if you can please assist me. I would like to find out how to create a formula that checks a range of cells and counts the number of rows since a specified value occurred last. For example: If I was looking for the last time 6 occurred it is 3 rows down in Row A therefore the...

I have this list of repeat callers in my database. I have already determined the frequency of calls but I want to rank them according to the time of call. For example I want to put "1" as rank to the first call occurred in July 1 1:00AM and I want to put "2" as rank to the sencond call occurred...

I have position numbers in column A. 1,2,3,4,5,6. Any number can occur for a given position. The numbers are in column C. So position 1 can have 45 occur X number of times. So, let's say that 45 occurred most often in position 1. I want to have a formula that will tell me which number...

I have been using this site for years and I just realized I've been a jerk and not officially thanked or liked any posts (I hadn't noticed the little icons for doing so). I had said thank you, but not used the buttons. My question is, would it be rude to go back through and thank or like all...

Hello! I am trying to find a way to automate a monthly process where I am downloading sales data from Jet.com/ Sears.com. Ideally, I would paste the data on a "jet" and "sears" tab each month, and then have it pull into the correct columns on a third upload sheet, if it occurred in whatever...

Hello, I want to conditionally format the highest value in a row. However, I only want to highlight the most recent occurrence of that value. For instance, in the table below, I only want to highlight the 6 that occurred on 4/21/2018, not the one that occurred on 3/31. When I try to write a...

In my spreadsheet there is one place that the user can enter a value that can cause an error. I have created an error handling routine that captures the error and clears out the cell the error occurred in. What I need is to make that cell active. Here is the error handling code I have created...

Hi I have a form. i need run a sub with textbox value as default values. something like this: Private Sub Submit_1_Click(Optional serial = TSerial_1.Value, Optional model = CModel_1.Value) but when I run it, an error occurred that you should use constant value. is there any way to fix it?

I'm not sure of the correct terminology for explaining my question, so please bear with me. Suppose I have a random event with a binary outcome (win/lose) and I have a set of data showing how many times win streaks of various lengths occurred. Here's the data for 668 "games". #Wins 0...