frequency of occurrence

Hello, If someone could help me, it can be vba or just formula in excel. My dilema is to make a scheduling calendar that tracks the frequency of lab test. For example, normally test should be done every three days, which will be recorded in the calendar. However, if for 20 days, the tests seems...

Hello, If someone could help me, it can be vba or just formula in excel. My dilema is to make a scheduling calendar that tracks the frequency of lab test. For example, normally test should be done every three days, which will be recorded in the calendar. However, if for 20 days, the tests seems...

Hello, I do bird surveys and I gather a lot of data. I am trying to calculate the number of point counts on which a species is present. My data looks like this: I am trying to find the number of times a sample station (column A), has at least one instance of a species (column E). Or put...

Hey there! I am trying to count the frequency a certain diagnosis (adenoma) is found within a report. The problem is that sometimes the report contains no adenoma found of no polyp or adenoma found, this can be worded in various ways. The data base I am using is extremely large so I cannot check...

Hello, I have a spreadsheet with error codes (column A) and timestamps (column B) . Every time there is an error, it is recorded and time stamped. I would like to write a macro that writes in another column (column D) the frequency of each error. I have filled column C with the distinct error...

Hi there, I want to simplify an excessively long nested IF(OR formula; can anyone help? Here is the formula: =IF(OR(I$6=$F15+$H15,I$6=$F15+$H15*2,I$6=$F15+$H15*3,I$6=$F15+$H15*4,I$6=$F15+$H15*5,I$6=$F15+$H15*6,I$6=$F15+$H15*7,I$6=$F15+$H15*8,I$6=$F15+$H15*9,I$6=$F15+$H15*10),1,0) I have...

I have a spread sheet with the following columns: <tbody> User name Date Time Time of Day Error Code Status John Doe 11/1/2016 12:25:01 AM 123 Success John Doe 11/1/2016 8:25:00 PM 123 Success Jane Doe 11/1/2017 8:25:00 AM 234 Failure </tbody> So I want to count how many times...

SUM OF MAX CONSECUTIVE FREQUENCY OF MATCH OVER MULTIPLE COLUMNS WITH MULTIPLE CRITERIA I wish to solve for the sum of the maximum frequencies in multiple columns with multiple criteria, using a formula that will prevent errors. IF D9="","", SUM MAX FREQUENCY IF D9 matches...

Hi all, I'm trying to calculate the frequency a value is used in a formula. I have a range of results (ranging numerically from 1-9) each connected to a topic/subject. I have created a cell which identifies the largest number amongst those results in every row (=LARGE(S5:AN5,{1{)). What i'm...

Ok - usually I can search these message boards or find a YouTube video, it's just not happening for me today. I am looking to count unique ID's in one column that meet criteria in three other columns. Column G = "" (blank) Column O = Completed Column L - Coaching Column F contains my ID's I...

I have a frequency problem I don't seem to find a solution for. Below you find an extract of just the columns I want to compare. I want to write a frequency condition saying: "How many values in Column C does only include D values in Column G and FALSE in Column L?". In this small example...

I would like to count how many unique values (= the frequency) in column A with the following conditions: * I only want to include values corresponding to an "X" in Column B * I only want to count the number of values in Column A which are constantly "Blank" in Column C. Meaning if I have a...

Hi, I have a spreadsheet with 130000 lines, and I would really appreciate some help in merging some of the data. I have searched the forum for help, and even though I found some related post, it did not solve my problem. I have lost of rows with duplicates of an unique ID (column A), and each...

Hi, I am trying to find out the frequency with which we service certain neighborhood recycling points. In one column I have the dates of service listed, and the next column I have this.... =(F6-F3)/count(F3:F500) formula to figure out the frequency. F6 is the most recent date, however, I am...

Hi, I have the start date of an event (say 20/03/2012) and it occurs every 6 months. How do I get the next date of occurrence, in this year in excel as well as the date the event last occurred.