Array selections
 

Ladies & Gents,
Hopefully my example below is not confusing :)

In essence I have a table of 13 columns and 200 rows with a purpose of
recording course details people attend.
The column headings are descriptions and each row is an individual record of
a course undertaken and so certain data can be duplicated i.e. dept, persons
name etc.
Example:

Dept Team Name Course ......
Admin 1 xxx yyyyy
IT 1 aaaa wwww
Cook 4 ccc yyyyy
Admin 1 tttt yyyyy
Admin 1 xxx www
Admin 2 sss www

Depending on the question asked of me I need to be able to generate 1 of 3
individual reports. The main keyword for report 1 is the 1st column, report 2
- 2nd column or report 3 - 3rd column description i.e. depending on the
question.

I've tried index and match, vlookup and hlookup but my main problem seems to
be checking and displaying each true record i.e. shows first then stops...

Can you help please....

Cheers
Colin

Array selections
 

Select all the data including labels in top row
Use Date | Filter -AutoFilter
Now experiment; for example see if you can display just the Admin team 2
data.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"UKMAN" wrote in message
...
Ladies & Gents,
Hopefully my example below is not confusing :)

In essence I have a table of 13 columns and 200 rows with a purpose of
recording course details people attend.
The column headings are descriptions and each row is an individual record
of
a course undertaken and so certain data can be duplicated i.e. dept,
persons
name etc.
Example:

Dept Team Name Course ......
Admin 1 xxx yyyyy
IT 1 aaaa wwww
Cook 4 ccc yyyyy
Admin 1 tttt yyyyy
Admin 1 xxx www
Admin 2 sss www

Depending on the question asked of me I need to be able to generate 1 of 3
individual reports. The main keyword for report 1 is the 1st column,
report 2
- 2nd column or report 3 - 3rd column description i.e. depending on the
question.

I've tried index and match, vlookup and hlookup but my main problem seems
to
be checking and displaying each true record i.e. shows first then stops...

Can you help please....

Cheers
Colin

Array selections
 

Bernard,

many thanks and I can do it this way but I am automating the process for
example - on asking the query the data is copied to a seperate formated area
so can be printed off.

I thought i should be able to do a vlookup to find the keyword i.e. dept
then maybe index and match to find the other elements along the row but I am
struggling to check each row.

Hope that makes sence.
Cheers
Colin

"Bernard Liengme" wrote:

Select all the data including labels in top row
Use Date | Filter -AutoFilter
Now experiment; for example see if you can display just the Admin team 2
data.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"UKMAN" wrote in message
...
Ladies & Gents,
Hopefully my example below is not confusing :)

In essence I have a table of 13 columns and 200 rows with a purpose of
recording course details people attend.
The column headings are descriptions and each row is an individual record
of
a course undertaken and so certain data can be duplicated i.e. dept,
persons
name etc.
Example:

Dept Team Name Course ......
Admin 1 xxx yyyyy
IT 1 aaaa wwww
Cook 4 ccc yyyyy
Admin 1 tttt yyyyy
Admin 1 xxx www
Admin 2 sss www

Depending on the question asked of me I need to be able to generate 1 of 3
individual reports. The main keyword for report 1 is the 1st column,
report 2
- 2nd column or report 3 - 3rd column description i.e. depending on the
question.

I've tried index and match, vlookup and hlookup but my main problem seems
to
be checking and displaying each true record i.e. shows first then stops...

Can you help please....

Cheers
Colin