frequency

Ok, so I have this formula looking at multiple criteria and giving me back a unique number (frequency) I use an array formula. My if statement looked to be if certain cells where blank. Well now I need to run the same formula but do same if cells are blank OR have text that say none. How the...

Greetings, I've been working on a project and after hours of searching and experimenting I can't get this to work. I hope this is possible with a bit of help from you guys :) There is actually two problems. I will start with the sequence of importance. 1) I have a list of names in (column B -...

I want to find the sum of the range within the sector within the zone but only summing unique values. For example, I want to find the sum of the Codes within Sector Ice Cream, Zone 1. However I don't want to count duplicates within that range. $63 Dollars should be the total of Sector Ice Cream...

Hi All I am trying to Sum the Max of consecutive numbers for cells greater equal than 2, for instance <tbody> A B C D Consecutive Sum Max 0 2 2 3 7 1 1 1 1 0 3 2 1 1 5 </tbody> Thanks!

I've set up a formula that is correctly counting my data using 1 criteria; however, I'm ready to add a second and third criteria to my formula. How do I nest in my 2nd & 3rd if statement? The additional criteria I need to add is Data!B2:B10000=K2 and Data!A2:A10000=L5...

I am looking to add something like a FREQUENCY criteria to this =IFERROR(INDEX($B$2:$B$5000,MATCH(SUMPRODUCT(LARGE(($E$2:$E$5000=1)*($M$2:$M$5000),ROWS($A$1:A1))),IF(($E$2:$E$5000=1),$M$2:$M$5000),0)),"") I have my index categories in Col B, and my LARGE in Col M, Col E is just a Month - if...

Hi, Is it possible to use Indirect & frequency formula together? Need a formula to count the score totals from sheet2 using Ref "Sheet2H:H" Thank you. <colgroup><col width="64" style="width: 48pt;" span="3"> <col width="114" style="width: 86pt; mso-width-source: userset; mso-width-alt...

I have a need to find out which Person has the highest number of reviews performed that found 1 defect Sample data: <tbody> Column A (Person) Column B (Defects Found) Column C (Reviews Performed) 1 1 0 65 2 1 1 42 3 1 2 85 4 1 4 54 5 2 0 25 6 2 1 74 7 2 3 45 8 3 1 108 9...

Hello, I'm new here and I'm must confess I'm ZERO in VBA. But I like the challenge to learn for some more. I need to create a table (table 1) from another table (table 2 in different sheet) in which a specific row (row1) from table 1 will be copied and pasted to table 2 a number of times as...

I am trying to write a function that looks through the data with the following characteristics: If the range of the data (cells A1:A500) has part number "abc-01" then I want to look at the value for that part (values found in range B1:B500) and see whether the value falls within 4.99 of a...

I have a gargantuan list of orders by item for each customer: Customer A - Item Z - Q1 - Order 1 Customer A - Item Z Q2 - Order 2 Customer A - Item Y - Q5- Order 3 Customer B - Item Z - Q1- Order 4 Customer B - Item W- Q2- Order 5 Customer B - Item W- Q4- Order 6 I want the number of times...

I've got the formula to identify that largest group of consecutive cells that fall below a threshold in a row of data and would like to show the column header of the first cell. Example data is below. I'm using a CSE (array) formula...

Hi All, First time poster so please be gentle. I am trying to get a spread sheet i have to auto complete a date based on another cells contents. <colgroup><col><col><col></colgroup><tbody> Frequency DUE Next PM 13 May 2018 13 June 2018 PF 14 May 2018 28 May 2018 PW 15 May 2018 22 May...

Hello, I would like to be able to get the column header of the first cell from an identified event of consecutive cells that fall below a threshold. Example data is below (column headers on 2nd row). I can identify the longest consecutive event, when more than one cell has data that falls...

I have a data set of different sites and different events that occur on them, broken down by month <tbody> Entity KPI Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18...

Hi All! I have two drop down menus consisting of dates using the Data Validation method. I'm trying to get the X axis to update based off of the input from those drop down menus. For example, if the user selects 11/1/17 and 12/1/17 the graph should update on the x-axis to reflect that range...

I have a data set, part of which looks as follows: <colgroup><col span="2" style="text-align: center;"></colgroup><tbody> X-axis Y-axis 50 50 50 100 50 100 100 50 100 100 250 100 250 250 250 250 500 100 </tbody> <tbody> 500 250 </tbody> <tbody> ... </tbody> Because I...

I have likert scale data: -29.0 through +29.5 I have four different likert scales that need to be graphed in some manner. the original thought was to create a bell curves to demonstrate the commonality of each set of data. - - That has proven difficult, or impossible as I cant figure it out...

Guys I have the scenario below where I would like to create a loop to distribute along the columns (G column on) the date that that maintenance will ocurr based on its ID, Frequency and Due date. I will distribute it for a period of 01 year (365 days or 365 Columns) For instance, the...

I'm trying to build the MASK column such that a 1 is displayed for the first distinct COMPOUND that has VOL * FLOW > 0, but I can't get it to work in the table using SUM(IF(FREQUENCY constructs; I get a "multi-cell array formulas are not allowed in tables" error. What other options would I have...