summarise

Hi All, I am having a brain block on how to summarize some data. I have a table with employee names in one row, and skill set status in a sheet (Its not a table, creating a table will cause problems for end users), with the skill set names in a top row. I am wanting a print out that shows by...

Hi, I am trying to use SQL to take all the data from my Table and summarise it on Week ID and Tier one can someone help please. This is whati am currently using but it gives all data and i want it to summarise all under Week ID and Tier 1 only how many occur underTier 1 by week. Declare...

Hello all, I am trying to summarise Value by IND (column B) and summarise in the 2nd table (columns F - column M). The query I am trying is to match 2 criteria - IND & Value <= value in column E. So , cell F3 & G3 has the count of values for Beta with Value <= 1.2 & Average Value for cases with...

Hi everyone, I am trying to automate a task to save time but my VBA knowledge is very limited. Hoping someone can point me in the right direction. I know that this question has been answered many times, but I have not been able to piece together code that works for my situation. Part of this...

Hi, Driver Sheet Monday <tbody> a b c d e f g h i j 1 12344 76544 46443 76542 12567 98534 12578 27533 85621 06345 2 ab cb ab cb hi jk ab no cb rs 3 4 16:35 16:15 17:01 16:50 18:00 17:50 17:35 18:05 17:30 18:07 5 17:00 16:45 17:30 17:25 18:35 18:30 18:00 18:40 18:00 18:45...

Hi Guys, So I have List of products sold (to customers) and purchases (into the warehouse) I am now looking to summarise the data to see which products are slow moving. The fields I have are <tbody> Item Code Color Quantity Date Sold - Purchased Invoice Number Status issue Status...

Hi, hope some of you gurus can help me please. I have a large download of data from a Gas meter, which I need to analyse to show a line chart with 3 lines: max, min and avg values for each time slot per weekday (M-F) and per weekend day (S-S). Time slots on X axis (horiz) & value of gas used on...

Hi, I've been creating a skills matrix with row titles of skills and column titles of job roles. Then the data in the table allocates required skills levels of those skills against roles. This gives me a nice matrix of all the roles, and all the skills. For example: Skills matrix...

A company I have just joined has a series of spreadsheets in individual workbooks which it uses as a costing document, there are quite a lot of cells involved such as company name, date, originator, hours, cost, equipment, etc, etc. I want to end up with a new spreadsheet that summaries the...