Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default Displaying Data grabbed using concatenates and CountIfs

Hi guys,

For work Ive been given the task of tranforming a table of Data thats extracted from a system, into tables and charts.

The data is to do with Health and Safety, reported accidents etc.
A group of 5 or 6 Divisions, each division has a multiple of Offices within.

A colleague sent me a spreadsheet she had created but thought it needed an overall with too many complex formulas included. I'd never used concatenates and CountIfs before, but slowly worked out what the code meant from the example. Using them both to link certain bits of data together to present.

Ive had a go, they recently upgraded me to ms 2007 for this, and wondering if the comparing of data & charts so far are ok?

There is one Main summary page 'Overall' referring to all Divisions and then each Division will have its own Sheet, idea will be each division sheet will be same design,layout etc just looking more in depth, and just alter the code. Ideally new data could be inserted into the sheet and automatically update everything itself...well when the data is consistent to meet my headings.

Any advice on how ive done, or maybe better ways to present or good data to compare?

Many thanks

Lee
  #2   Report Post  
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by woodland81 View Post
Hi guys,

For work Ive been given the task of tranforming a table of Data thats extracted from a system, into tables and charts.

The data is to do with Health and Safety, reported accidents etc.
A group of 5 or 6 Divisions, each division has a multiple of Offices within.

A colleague sent me a spreadsheet she had created but thought it needed an overall with too many complex formulas included. I'd never used concatenates and CountIfs before, but slowly worked out what the code meant from the example. Using them both to link certain bits of data together to present.

Ive had a go, they recently upgraded me to ms 2007 for this, and wondering if the comparing of data & charts so far are ok?

There is one Main summary page 'Overall' referring to all Divisions and then each Division will have its own Sheet, idea will be each division sheet will be same design,layout etc just looking more in depth, and just alter the code. Ideally new data could be inserted into the sheet and automatically update everything itself...well when the data is consistent to meet my headings.

Any advice on how ive done, or maybe better ways to present or good data to compare?

Many thanks

Lee
Hi Lee,

Bit awkward to say how you've done if you don't attach the workbook....

S.
  #3   Report Post  
Junior Member
 
Posts: 2
Default

Quote:
Originally Posted by Spencer101 View Post
Hi Lee,

Bit awkward to say how you've done if you don't attach the workbook....

S.
strange i uploaded it, ahh it was above the file size even after i compressed it.
100k is poor limit if your spreadsheet has graphs etc in

http://www.speedyshare.com/hdy36/health.zip

Last edited by woodland81 : June 7th 12 at 10:27 PM
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need macro that concatenates cells with text andrei Excel Programming 7 September 27th 09 04:06 PM
printing a file excel just grabbed from IE thomas donino Excel Programming 0 August 30th 09 12:45 AM
Countifs to Sumproduct for 2003 - was Simple Countifs.. from Fr Steve Excel Worksheet Functions 2 January 4th 09 06:36 PM
CONCATENATES gfrechette Excel Worksheet Functions 2 July 6th 07 12:48 AM
Removing concatenates for VBA calculs Werner[_14_] Excel Programming 2 June 29th 05 07:21 PM


All times are GMT +1. The time now is 09:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"