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