frequency

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

So far my formula (non-working) is as follows. =SUM(IF(FREQUENCY(IF(CritDateTest<=CritOutDate AND IF(ISNUMBER(SEARCH(Vuln1,CritVulnTitleTest)),MATCH(CritIPTest,CritIPTest,0)))),ROW(CritIPTest)-ROW(CritIPBeginTest)+1),1)) or...

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