Displaying Data grabbed using concatenates and CountIfs

[woodland81]

Hi guys,

For work Ive been given the task of tranforming a table of Data that
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 Office
within.

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

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

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

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

Many thanks

Le

 

[woodland81]

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
compressed it.
100k is poor limit if your spreadsheet has graphs etc in

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