stats

  1. L

    Copy date from a different Sheet

    I want to be able to copy data from a different sheet to a specific feel in a another sheet. I have a sheet named GSO Inventory Stats and a sheet named Retag metrics. I need to put a formula in Column I, that if Column H in sheet GSO Inventory Stats matches the sheet named Retag Metrics Column...
  2. L

    Copy Data From Sheets

    I have a Sheet Named NEA Status and a sheet Named Inventory Stats I want that if Column D in Sheet named NEA Status Matches Column D in the sheet named Inventory Stats move the data from Column H in the sheet Named Inventory Stats to Column H in the sheet named NEA Status.
  3. F

    Excel stats verses Matlab, R and Python

    Hi Everybody, Can anyone provide some pros and cons of each of these stats packages for a general professional level but not for full on data science work. thanks, Farmerscott
  4. P

    Change Source Data with a Pivot Range excel 2010

    Hi - is there a simple way of knowing where the Table range is looking at if the file path is long and the file path is not in the same file - when I click in I cant see and then the file path stats changing Thanks
  5. P

    copy data from one workbook to another

    Hi I have the code below where I am trying to copy a range A1 to G15 into another workbook but its not working please can you help. I am trying to copy from Daily stats into Daily Stats WC Template, hope you can advise? Private Sub CommandButton1_Click() Dim x As Workbook Dim y As Workbook Dim...
  6. A

    Worksheet Tab Being Renamed During Save Process & Unable to open newly created .xlsx file (invalid file extension?)

    Please consider this code ... With wb_classcsv .Sheets.Add(After:=.Sheets(.Sheets.Count)).Name = "Stats" Set ws_stats = .Worksheets("Stats") With ws_stats .Range("A3") = "Date: " .Range("B3") = Format(usr_date...
  7. S

    Don't update formula after certain date

    I fear there is not going to be an answer on this, but I have a formula where it counts values between certain dates, however, as this is for a weekly stat sheet, I want the calculation NOT to update after a certain date.. ie if the stats are for week commencing 1A April, after the 8 April, I do...
  8. B

    VBA if Vlookup problem

    Hi, could someone help me with this please, I am ok with excel but new to vba and my problem is this: I have a userform with just a few textboxes and it is the first one I am having trouble with, I would have done it ages ago in excel but anyway, the userform is on a sheet called "start" and...
  9. M

    power Query Premierleague.com

    Hello. I am a football Stats man, and I have been trying to run a PowerQuery using my very limited knowledge with even more limited success! For example on this page : https://www.premierleague.com/stats/...s/goals?se=210 I am looking for this information here: It is struggling to find any...
  10. K

    Need Help on making a list of words based on the below requirement

    ----------------------------------------------------------------------------------------------------------------------------------------------------------- Example String: "calculating cumulative stats for quarters"...
  11. Z

    How do I predict the future? Stats people needed.

    HI I have a series of 5 totals for each year, the slope function over the 5 totals returns 57.6 How do I apply the slope to a subset of the totals The total are 2106, 2008, 2147,2288. slope = 57.6 My subset is 131,158,138,132,547. I want to predict the next number ignoring the first 3...
  12. M

    Index/Match VBA

    ActiveCell.FormulaR1C1 = _ "=INDEX('Department Adherence'!R[-16]:R[1048559],MATCH(""Department Total"",'Department Adherence'!C[-1],0),3)" Is there a way to amend this formula so that it actions the formula in column "C" only if column "B" equals "Department Stats" If column "B" equals...
  13. Y

    Formula that skips rows when Copy Pasted

    In the "stats" tabs, I am trying to add info to each row for each employee. In the "Document" Tab I want the info from "Stats" Tab to populate but when I copy the formula down I will skip about 33 lines in the actual sheet. For Example: "Stats" A2= "document" C2 "Stats" A3= "document" C15...
  14. M

    VBA Excel If Statement

    I need a bit of help writing some code. I have a spreadsheet to track stats of a teams performance however the system that is used to generate the stats does not produce a team total so everyday i have to go in and manually add the formula. I was going to just do a basic =sum formula to total...
  15. kpasa

    Preferred Method to aggregate daily data

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

    CountIfs seems to be adding values together

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

    Formula to sum rows and columns with multiple variables or VBA to do this

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

    Index, Match, Max, If

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

    Index with Match and Min/Max

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

    Some assistance - 1 workboot, multiple sheets

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

Some videos you may like

This Week's Hot Topics

Top