stats

Hello Community! I'd like to get your thoughts on how I should approach a new project. We get a daily report from one of our partners with subscriber usage stats. It comes in the form of a CSV and is only 1 day's worth of data. Our goal is to aggregate the data in order to do calculations on...

Hi All, I have the below code to count through columns BL, BM and BN on my Completed Sheet. The information entered into these columns can be - 1.1 or 1.2 or 2.1 or 2.2 or 3 or 4. The information is then pasted into OverallStats Sheet columns C22 to E28. Row 22 being 1.1, Row 23 being 1.2...

Good afternoon all, Again, thanks to all the contributors on this site that make my day job easier! I however have another question which I am sure will be extremely easy for someone else. I have two worksheets; Stats sheet and cumulative views. The stats sheet contains details of...

I'm using this array formula to return the max date where the primary key matches in 2 different worksheets, and it works fine. {=MAX(IF(Specs!C:C='Info'!C2,Stats!H:H))} I'm trying to get the value in column J on the Stats sheet, for the same line. I've been looking at this for a few hours...

I'm trying to get the max value from column AG on the Stats worksheet, where the value in column C of the Client Summaries Sheet matches the value of column C on the Stats sheet. From the couple of examples I've seen online, that actually list all 3 parts, this is coded correctly, but I'm...

Hello all. This will be hard to put an example and I apologize. I have a lot of data on a sheet for November (months worth) for employees based off 7 rows. I then have an error sheet where I have the errors listed for all employees. What I am looking to do... I have a sheet called Employee...

Hi im looking to do a couple of what i think are simple formulas but with two criteria i cant seem to make it work I have attached an example sheet, One sheet will just have essentially all the raw data i guess you could call it then another sheet will have the two boxes on the right. One for a...

I need 2 SUMIFS formulas I have 2 worksheets; SALES & STATS on STATS H28 is where the formula is needed. I need the formula to SUM S6:S1005 IF both criteria in SALES I6:I1005 = "CL" and SALES E6:E1005 = "B" Same formula needed for Y17:Y28 with the exception of E6:E1005 = "S"

This is hard without being able to upload a WS but here it goes. I basically need a 2 SUMIFS formula I have 2 worksheets; SALES & STATS On STATS M17:M28 starting on M17 I have al 12 months of the year listed as 1/1/2017, 2/1/2017, etc. on STATS W17:W28 is where the formula is needed. STATS...

Hello everyone :) The code I`m using at the moment works and I get the needed data. BUT, unfortunately, the code is really slow... I use the macro to select a folder in Outlook and then extract all email information (name, sender, reviser and so on.), based on a week. So basically, a weekly...

The macro below makes a copy of a range of cells just before updating them so I can see the changes. It was leaving the range selected, so I added the last statement, but the range is still left selected (walking dotted border). How do I cancel the selection? Sub CopyErrorRow(inRowError As...

Hi, I run a sports club (cricket) and keep a tally of all the stats for the team. I am trying to create alerts when certain cells reach certain levels for the first time. Each year has a spate sheet with all the stats with a sheet totalling all the stats. So for example, over the last 4 years...

Hi, I have some working code that I'd like to expand on. Basically I'll have a bunch of individual cell addresses "AB10", "AD10", ... "CZ10", and so on that i'd like to compile some basic statistics on. But when I try to get the values in a way that's easy to work with, like in this example...

Hi, I deal with MI within my department. At the moment I have a master file where I document weekly stats, however I do it manually. Weekly stats I get in excel format. It always looks the same way: column A: process name column B: items column C: time Then I manually take the stats I need...

Hi all, I am extremely bad at verbally explaining things, so I hope I'll manage to explain what I need clearly. :eeek: I have a "case tracker", where I track actions on cases and their status. There are several actions in the process (5+). Below is a very simplified example: So basically...

I am creating a new KPI (Key Performance Indicator) dashboard for my company. One of the stats included is our ASA (Average Speed of Answer) and I'm trying to input the weekly numbers for each department and they have a MTD & YTD portion that will give us the overall average. The format of this...

Hi All I'm trying to find ways of getting relevant statistics for my local pub darts team. Below is a picture of one 'tab' from the spreadsheet. I have a separate tab for each game we play in the season. As you can probably guess, a lot of the content is already automated. e.g. the score in...

I need to do an audit of 5% of each of my coworkers complaint files. I pulled the data so that Column A contains the complaint file number, and Column B contains the complaint owner. There are about 7 different owners, but every complaint file number is different. I need to pull out a random...

Good morning everyone, I have a question in regards to Statistically Significant Sample Sizes to a population. I am working with data in excel and wanting to put the formula for this into the workbook as well but have run into a roadblock of sorts. I am probably over thinking it but have been...

Hello, I wonder if anyone can help e create a rolling 12 months stats table like the one below: The date in the October 2014 column is created using the =now() formula which has been formatted to MMM-YYYY. In the columns for the preceding 11 months I have used the EOMONTH formula again...