Search & Display multiple results (Excel)

[Icarus050]

Hey all,

I need to setup a search and results display for a spreadsheet.
It looks like so:
Persons Name | Reviewer Name | Due Date

Names are obviously plain text, and the due date is either 1-10, 11-20 or 21-end.

I need to be able to search for all the records with the reviewers name and a particular date range and display the result somehow.

So it will look for all the reviews a particular person needs to do from the 1-10 and display the Persons Names in the result.

Cheers.
Ic.

 

[SkipVought]

Icarus050,

Where is your source data?

What does the format of your source data look like?

"...due date is either 1-10, 11-20 or 21-end...."

This is not a DATE, rather it is a Day of the Month. How is this data stored?

Skip,

_[red][/red]

 

[Icarus050]

Ok, here's an example

Persons Name | Reviewer Name | Due Date

John Smith   | TIM           | 1-10
             | JAMES         | 11-20
             | AMY           | 21-end

Joe Bloggs   | TIM           | 11-20
             | JAMES         | 1-10
             | AMY           | 21-end

Alan Smithee | TIM           | 21-end
             | JAMES         | 11-20
             | AMY           | 1-10

Etc etc for 220 people.

So yeah, I need to have excel tell me the names of all the people TIM needs to review between the 1-10, then 11-20 then 21-end.

 

[Icarus050]

Never mind.. I discovered the wonders of Pivot Tables..