data analysis

Hey Guys, Thank you for reading my question(plea for help), I really appreciate your help (I'm on my knees, begging) I am making a bowling league excel sheet, I will have 10 - 15 teams. Each team will start of with a rating. - There may be no games on a particular day, or more than 1...

Hello, I need a simple formula for calculating Average Time Between Calls, aka Prep Time or Average Idle Time. I have done this in the past but can't for the life of me, remember my old formula. Some call center reporting does this for you, but not the one my company uses. Here is the data I...

I'm new to the consolidation feature in Excel. I have shared a link to the drive doc in google. https://docs.google.com/spreadsheets/d/1SJ7e85R5Hm1Nc6DQRJcYAhl4PPfX3lV7HfbZq4xrOuw/edit?usp=sharing I have some columns which are in percentages (conversion column), I would like to sum these and...

Hi all - head is twisted in a knot... I have the following: NameProduct 1 Product 2 product (n) Name 2Product (p) Product (k) Name 3 To the right of each product I have amount. I want to do basic analysis by sales per product per client. I don't know how to get this data in a table. I could...

Hello everyone, This is my first post here, and I just joined the forum after searching around and learning a few things about setting up my data entry table for later analysis of survey responses. I'm pretty excited about learning how to do calculations with Excel I've never even considered...

Hi All, I am new to the world of VBA, and have starting to feel a little frustrated with something I thought would be simple enough to do, but isn't working the way I would have hoped. I have a large table of data with three columns. The first column consists of an ID value incrementing from 1...

Guys URGENT test on Excel data/data analysis PLS help! I will put a link to the excel file below, all I know it contains phone tariff cost info and accounts that say a phone company may use. That's all I know and not supposed to know anything else. I need to say 1. What conclusions can I draw...

Hi guys, I'm working on a project where I have to analyse reviews, gain feedback reviews and produce charts. Let me show you some example data... <colgroup><col width="64" span="26" style="width:48pt"> </colgroup><tbody> reviews Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13...

Hi there. I have a list of electricity use data that I need to use to create a chart. Each row entry contains a calculates an hourly kilowatt hour use extrapolated from an average kilowatt hour use for 15 minutes (so if in the 15 minutes there is 25 kilowatt hours of electricity used then the...

Hi all, I have a list of applications listed in columns in row 1. Let's say Column A = Adobe Reader, the rows below it list the users with Adobe Reader installed. I'm actually wanting to have the names in row 1 instead of the application name and list the different applications the name...

So this is what i need to happen, I have a HR list and another list for an application Suppose i need to find if the account on the application is on the master list i need to copy the data into a new worksheet (Master List) and if there is no other verification of the account, it will go to...

Hi All I am using the below code to extract non filtered lines to another to another sheet later on. It was working fine, but as I keep modifiying it, I'm now getting funny results? Does anyone have any idea what I have done Sheets("Sheet1").Range("B23:D37").ClearContents...

Hi, I have a list with the following names: Location | Date | Count of clients (only fron that date) | Employee I created a Pivot table to show me how many clients we received a day for the locations (Easy) Location Names <- Dates -> |...

I have a tab in Excel in a normal database style. One of the columns categorises the items. I then have subsequent tabs - one per category - where I want formulas e.g. a vlookup to extract all the entries in that category from the base sheet. I can do this with a vlookup or IF function...

Hello All, I'm trying to create an excel formula that takes the current PC system date, compares it with a list (4 years worth) of events matched with time/date and produces the most frequent event for the PC system date. A macro button would be used to trigger the formula Example: PC System...

Hello, I am initiating me into this but can not find syntax and i hope you could help me, i have a workbook with multiple spreadsheets A1, A2, A3, A4, ...... and I have information in each table, i need a macro to select the range of information and consolidate them into another file, ie the...

Hello there, I'm not sure if the subject of this thread accurately reflects what I want to be able to do, but it's the closest description I could think of! I need a formula that gives me the answer to this formula =COUNTIFS(AD3:AD1383,"yes") The above formula is based on the answers in each...

Hi Guys, I wanted to ask for some advice on finding Room clashes (e.g two classes happening in the same room on the same date. My aim is to apply whatever method is advised to a large amount of data (1000 classes in 20 different rooms). eg. below: <tbody> ROOM COURSE START DATE END DATE...

Hello gang! I've got two question on how to 'find' some values in a specific data file, namely: - the '52-Week High' of the share price (highest value of the share in that specific year) - the value of the share price of the last trading day of that specific year (this isn't always 12/31/20..)...