I have some data, contained in a spreadsheet, generally arranged in a fixed
number of columns. I need to do some simple analysis of these columns of
data. Easy enough. But.....
The data comes in to the spreadsheet as different "groups" of data, with
each group having varying numbers of rows, but all using the same columns.
Furthermore, each group of data has a single row "title" to identify it.
There are blank rows between each group

Example:

Group 1
10 lines of 6 columns

Group 2
8 lines of 6 columns

etc.

The type of data in each column is the same. How do I extract/analyse the
data that is contained in each part of the column that relates to each group
of data? I don't want to have to manually rearrange the data as this will be
time consuming. Sorry if this is a simple question, but I am a simple user!
Help would be much appreciated.

What kind of analysis do you want? Are you adding the columns, or
counting them, or taking an average by each group?

You can use SUMIF and COUNTIF to achieve these aims, but if you want
the minimum or maximum of each group, say, then you would need to use
array formulae.

Please be more explicit about what you want to achieve. Also, it would
help if you can give details of the columns you use and what type of
data is in them.

Hope this helps.

Pete

On Nov 12, 10:27*am, bananaman
wrote:
I have some data, contained in a spreadsheet, generally arranged in a fixed
number of columns. I need to do some simple analysis of these columns of
data. Easy enough. But.....
The data comes in to the spreadsheet as different "groups" of data, with
each group having varying numbers of rows, but all using the same columns..
Furthermore, each group of data has a single row "title" to identify it.
There are blank rows between each group

Example:

Group 1
10 lines of 6 columns

Group 2
8 lines of 6 columns

etc.

The type of data in each column is the same. How do I extract/analyse the
data that is contained in each part of the column that relates to each group
of data? I don't want to have to manually rearrange the data as this will be
time consuming. Sorry if this is a simple question, but I am a simple user!
Help would be much appreciated.