frequency

I run a maintenance business and I've decided to make an excel sheet that tracks if my technicians are keeping up with their service on a weekly, biweekly, or monthly basis. I figured the easiest way might be by changing "biweekly" to 14 and "monthly" to 30 like I set up the true/false...

Hello, I'm looking to accurately countifs a long series of data and remove the duplicates from that series based on another column's values. It seems like it shouldn't be that hard but haven't been able to find a solution. My data set has 10,000 rows, so I am not looking for a pivot table...

Hello, I am trying to create a word/phrase counter where it counts the contents of the cell (regardless of how many words are in there), and shows how many times it appears in the range. I apologize if it sounds confusing, but here is the example: Source: Genre Number Historical...

Hello All, I've been trying to figure out a clean way to determine and show how frequently a cell value occurred based on another cell. Here is my example below: For automotive spark plugs, I want to know where spark plug AC_104017 was stocked the majority of the time. The answer is warehouse...

I've collected some vaccine administration data that I want to analyze for unique patients in different age groups based on their registration date. So far I have used a Sum - IF - Frequency equation to determine the number of unique patients depending on the date the patient was registered...

Hello, Please see below table: ABCDEFG1ValuesValueOccurrenceNew count of values:652BBBAAA10%3AAAAAB5%Values:4AABABA15%5ABAABB15%6AAABAA15%7ABBBAB15%8BABBBA15%9BBABBB10%10BBB11ABA12BAB13BAA14BBA15ABB16BAA17BBA18ABA19ABB20BAB21BAAD2:D9D2=COUNTIF($A$2:$A$21,C2)/20 Column C contains a list of...

Akuini submitted a new Excel article: VBA Macro to create Word & Phrase Frequency - VBA Macro to create Word & Phrase Frequency Read more about this Excel article...

This macro generates word & phrase frequency. You can set the number of words contained in a phrase as needed, in this part: Const sNumber As String = "1,2,3" You can also set what characters should be considered as word characters, in this part: Const xPattern As String = "A-Z0-9_'" but...

Hi, Example of my 200k row data: ABCDE1TimeA21:00:00.0001.52:00531:30:00.0001.542:00:00.0001.252:01:00.0001.262:45:00.0001.372:50:00.0001.382:55:00.0001.592:59:00.0001.5102:59:08.0001.9112:59:59.0001.9122:59:59.0201.4133:00:00.0001.11422:00:00.0001.4A Column : Time B Column : Value D Column ...

With below formula I am counting unique values. Everything worked well until I added the dates. Any suggestions to solve this? Picture attached =SUM(--(FREQUENCY(IF((N:N="Installer/Contractor")*(ISNUMBER(SEARCH("|"&I:I&"|";"|Visit|Online Meeting|Webinar|Join Visit|")))*(ISNUMBER(SEARCH("Ole...

Hi, what formula do I need to show the amount of unique orders, linked to location 18 and delivered or not? The formula used for unique orders: =SUMPRODUCT(((ISNUMBER(A4:A25))/COUNTIF(A4:A25;A4:A25&""))) The formula used for location 18 (SHIFT+CONTROL+ENTER)...

Hi VBA Gurus, I am looking for below excel macro..if that is possible..."Basically trying to set timer and frequency counter - for which values go below and above certain values (Please refer screenshot attached for exact format)" 1) Column A has Ratio which is formula fed by system feed...

Hello All! I'm trying to create a formula that counts the number of unique dates within a date range based on the type of item. I've tried several different formulas and researched ways to do it, but each formula was so specific to the poster's specific problem, that it did not work so I...

Hello everybody, I want to count unique value with following formula, which usually works, but does not for this task. The extra add on is Data'!$AA:$AA;"*Dahl*" (I believe this is the reason it's not working) =SUM(--(FREQUENCY(IF(('Visit Data'!$AD:$AD="Distributor")*(ISNUMBER(SEARCH('Visit...

Morning all, I've got a working Sum Frequency formula which counts unique matches. =SUM(--(FREQUENCY(IF((Driver!$A$2:$A$1973='Data Selection'!$A$1)*(Driver!$G$2:$G$1973="No"),MATCH(Driver!$D$2:$D$1973,Driver!$D$2:$D$1973,0)),ROW(Driver!$D$2:$D$1973)-ROW(OFFSET(Driver!$D$1,1,))+1)>0)) It works...

I am using these 3 formulas to return the #1, #2 and #3 top referral source, in other words the value that appears the most times, 2nd most times and 3rd most times. It has been working perfectly until I today when the #2 and #3 happened to appear the same number of times. The result is that the...

Hi guys, I have tried googling and the things that I know. However, I am not getting the solution. I have an asymmetrical data set of names. It has approx 20000 rows. Column A is never empty for any of the rows. The farthest column that holds a value in it is "HZ" (not all rows have values...

Hi I'm hoping for some help to create some stats on the status of working through client jobs. First I must state that I can't use a pivot table or Visual Basic solution as there is a shared workbook which I don't control. I've simplified client on boarding in an example. I was wondering if...

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

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