frequency of occurrence

  1. C

    How do you count occurances of something over a period of time?

    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...
  2. G

    Sum of max consecutive frequency match with multiple columns and multiple criteria

    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...
  3. F

    Counting the frequency of a value used in a formula

    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...
  4. Amosbroker

    Frequency Formula - Meeting multiple criteria

    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...
  5. S

    Frequency problem desperate for solution!

    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...
  6. S

    Count frequency with multiple conditions

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

    Merge duplicates in ColA while picking most frequent value in ColB

    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...
  8. J

    Auto Select Last active Cell in a column

    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...
  9. S

    Date functions

    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.

Some videos you may like

This Week's Hot Topics