frequency

  1. N

    Database as weekly reminder

    i have a series of clients that need work doing. each one has house work on at a different frequency. some weekly, some 2 weekly, some 6 weekly etc. in additional these clients have garden work on at a different frequency I would like to be able to add these clients to a database, say the work...
  2. 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...
  3. S

    If, then formula for matching the count

    Hello! I'm new to this forum and am hoping someone can help me with a formula. I'd like to return a text if the count of a text of a range matches the count of a text in another range. Ex: Range 1: Return Text: Data Input (these will be dropdowns)...
  4. G

    Calculate Median from Frequency Table

    Hello, does anyone know of a formula to calculate the median from this frequency table? (assuming the list goes on, way beyond row 10) <colgroup><col><col></colgroup><tbody> number frequencies 0 1240 1 2395 2 5538 3 9837 4 14545 5 16061 6 21340 7 25770 8 22434 9 17497 10...
  5. E

    merging formula - assitance

    Mr Excel Query I currently have two formulas that I am trying to combine sothat the combined formula provides both outputs required I wonder if anyone could assist on the basis of info provided below The formal below are the 2 current versions I have in a cell W7 I would like to combine them...
  6. G

    counting trends over time - by hour, and by day

    Please forgive my appalling lack of Excel vocabulary. I'm not even sure what what I'm trying to do is called. :) I have a spreadsheet to track the time and frequency of occurrences, say phone calls. My data is like: Weekday Date 9:00 hour 10:00 hour 11:00...
  7. srizki

    Frequency formula

    I have names in column A, and frequency in column B, some fames are repeated 10 times while most of them are only once. I have count if formula in column B, I need a formula that adds up the frequency only once. So if let’s say name UK appears 7 times, US 11 times and Pakistan 4 times, Sweden 4...
  8. J

    Need Help?? (Not sure what function to use)

    Hi, I am trying to write a formula that will tell me if a client is new or existing. Below is some sample data of the file I am working with. <colgroup><col><col><col span="25"></colgroup><tbody> Client New/Existing Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17...
  9. 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...
  10. S

    Frequency function with text

    Hi everyone, below are two columns and I want result from column1 like below here in the RESULT column, I can't use frequency function because values are not strings. Could you please help me here? <colgroup><col><col></colgroup><tbody> COLUMN1 RESULT SVC-1 2 SVC-1 0 FALSE 0 FALSE 0...
  11. B

    Purchase Frequency Worksheet

    Hello all, Would anyone have a Purchase Frequency Worksheet they wouldn't mind sharing. I am able to extract the data from our system, I just want to put it in a spreadsheet and make any changes for our needs. Any help would be greatly appreciated. Bob
  12. P

    detect in the front pair in each group of the corresponding 7 and its frequency

    please detect the front double of the pick3 and see the amount of each groups. Step 1, put the pickings of the pick3 in ascending order Step 2 separate the front pair. 3º detect in the frontal pair in which of the 7 groups 4º to see the frequency (quantity of each group)...
  13. T

    Frequency syntax

    Hello Recently I got some help on here putting a frequency function into a worksheet. I've been using & adapting this as required. This is typical of the formula I've been using. {=SUM(--(FREQUENCY(IF($V$4:$V$498="UNITED 1",MATCH($AD$4:$AD$498,Nov2018Daily!$AD$4:$AD$498,0))...
  14. T

    SUM COUNTIF Horror

    Peoples, Could someone do a good deed an help me manage this disgrace of a formula into something more succinct? As you'll see it's calculating the frequency of 'yes' against the frequency of 'yes' and 'no' depending on the condition in B5 is met. It's actually part of a much larger formula...
  15. C

    Combining COUNTIFS with FREQUENCY?

    Hello! I have the following set up Column A - Date of Transaction Column B - Transaction Number Column C - Transaction Category ("Purchases", "20% Off Sale", "Employee 10% Off Discount", "Comp") Column D - Item For example: <tbody> A B C D 11/15/18 19816 Purchase Candle 11/15/18 19816...
  16. C

    Do the items in Bin Array (Frequency Function) have to be sorted?

    I have browsed a lot of Excel websites, and the result is yes. But when I try it out myself, I think Excel somehow arranges the items of the bin array in ascending order when it executes the Frequency function, no matter how randomly you put them in the list. Anyone cares to share their...
  17. M

    SUMIFs - simple example

    Hi I've got a table where I want to add the sum of occurrences for two different letters (see below): A appears twice, B appears thrice and C appears 4 times. Assuming that this data covers two columns and 4 rows from cell A1, how would I write a SUMIFS formula that captures the number of...
  18. A

    Muliple criteria Using Frequency and Match Formulas

    Hello, I am trying to calculate the frequency how many of my students have responded in discussion boards. So first, I need to find a formula that will count the names excluding duplicates. I also want this formula to work if there are blank cells. Second, the students are all divided up between...
  19. P

    List Values By Frequency

    Hello! Let's say I have 1 column. I want to list Values from most frequented to least frequent. Column B 1 5 6 9 11 12 9 9 5 5 5 1 I want column C to return the values in the order of frequency. 5 9 1 6 11 12 Is there a way to do this? I can't sort the column due to other columns.
  20. M

    Excel VBA macro to import and sort data from one file into another

    Hello, I am new to this site and to VBA, so please bare with me. I need a macro for work to import data from an Excel file into a "Master"-Excel and sort it in a table. The task is to list occured events based on calendar weeks (CW). The input (separate Excel file) is the frequency of events...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top