averages

Good Day all, I have created a database with frequency values that are mostly monthly however their is one set of data entries that are daily. This is an issue because my preferred data format is monthly. I would like to create a query that can generate monthly averages from my data...

Hi guys, I need a correction for my formula, I want to calculate averages for given dates, Dim FirstDate As Date Dim LastDate As Date FirstDate= Application.InputBox("First Date") LastDate = Application.InputBox("Last Date") Range(Cells(3, anay), Cells(3...

Hi, I am trying to create a macro to create a graph on some data from the spreadsheet. To do this I have recorded the macro of the graph I am trying to create being raised manually. The table I am trying to show data from is quite obscure and I am having to edit the graph plotting points...

I have a command button that is averaging multiple cells (doing several averages). If one of the cells are empty than that cell doesn't get added to the average. If I were then to fill in that cell with a number and click the command button it would rerun the entire code including the other...

I have 6 tables like this. each has 72 rows. Is there an option to represent all of those as 1 table with average values of all 6 as content. So the output would be same columns and rows as this one, but content should be averages of all tables. Is it possible and how?

I have a workbook with 100+ sheets. Each sheet represent a time point. I would like to plot the averages of the values for each time point. This clearly doesn't work by just expanding the table, so is there a solution to this problem? Secondly, each time point sheet is actually a table of...

Hi, I’m looking for a solution that can count the number of times averages occur in a table based on several criteria. Looking at the picture below, I’m trying to work out a formula that can go into cells N17:N20 that will calculate the count of averages that meet the variable criteria in the...

Good morning! I might just need a coffee, but... I have a data set that I need to calculate averages in. In Column A, I have Function, in Column H I have Status, in Column S I have a calculated field showing No. of Weeks Active. I need to pull out info using the following example: Countif...

Hi everyone, I've got a problem where my solution just isn't good enough and I'm hoping someone will have a better idea. The problem: I have to report vehicle utilisation by month, by region, and by "category" (front line, second line, specialist, and average). I need a line/bar graph that...

I've a list of servers (rows) that I'd like to spread a total load across. Each has a max load, & a recommended % load threshold to prevent issues. Different servers have different max loads. (Note... For the non server nerds equally this could work for team members and tasks rather than...

Hi again all Not sure where to start with this one, so I'll try to keep it brief. We have two sets of cells on separate rows that contain lookups to a separate table for each row. These return some decimal values. <tbody> Name1 Name2 Name3 Name4 Name5 Table1 Lookup 1.02 1.12 1.3 0.89 0.91...

I have project for work where I need to find the average fico score for each branch within an excel file. The way i have been doing it is just filtering the branch number and then finding the average that way. Although this works, I have around 1000 branches i need to do this for. Any tips to...

Hi! I'm trying to use a formula which can find the averages for a teams last score in the last 3,5,10 games. I've got an example of the table below and how it would look when I've got it working https://docs.google.com/spreadsheets/d/1bY3PJSTGC2NSXMEVHxfaJFeYGJYoB47qursB9aQo07g Would love to...

Hello guys, question regarding averages: I am looking for a way to average the time in the columns with hours and that for each column. It may only select the lowest value of the lines with duplicates (since this time stamp is relevant). Any ideas? Been trying with averageifs, min, ... but...

Hi I'm looking for help on isolating and breaking down some figures Customer Type Payment Credit Limit Credit Check Total Amount Difference Bus test 1 Direct Debit 90 <=100 80 10 Business Cash 90...

Hi, i have a table that i want to extract from. 1st 2nd 3rd etc eg <tbody> team average position TEAM GIANTS 1.000 FIRST TWINS 0.000 SECOND RED SOX 0.750 THIRD METS 0.500 FOURTH </tbody> See above. in B5 i want it to automatically choose the highest...

Excel 2007 windows XP I am trying to group columns of dates so that they show either quarters or years when the initial data is by month. The problem I have is that I want the results to show the total qrt/year as an average in the 'summarise value field by' within the field settings. However...

Hey guys. I'm trying to create a code on vba that generates all the daily averages for different combinations of hourly data, starting with the full 24 hour data, and then averaging all the combinations of that day with 1 hour less, then all the combinations with 2 hour less, and so on untill 8...

I've got worksheets that have information about a different persons utility usage on each row. Column A has the name, Column B has an ID, Column C has the type of utility (GAS or POWER), and D has their usage (just a number). I need a macro to go through each sheet in the workbook and put...

Hi, hope you're doing great today. In column B, I have # of events, like this: <tbody> 2 1 1 2 1 4 </tbody> In column C, I have Day number of week, eg: <tbody> 1 (Sun) 2 3 4 (Wed) 5 6 7 (Sat) </tbody> In column D (if you want to use this instead of day number)...